You plan to create several datasets by using the Power BI service You have the files configured as shown in the following table.
You need to identify which files can be used as datasets.
Which two files should you identify? Each correct answer presents part of the solution
NOTE: Each correct selection is worth one point
A. Data 1
B. Data 2
C. Data 3
D. Data 4
E. Data 5
From the reference, https://docs.microsoft.com/en-us/power-bi/service-get-data, states you cannot have over 1GB size limit. Looking at the image, Date 2 and 4 are over 1GB.
Power BI does not support TSV directly and I myself couldn’t find any information to support TSV on this, but TSV can be converted outside Power BI from Azure’s Data Lake Store or another work around via text editors. Maybe replacing the tab/spaces or some form of replace within Excel prior.
For the JPEG, its an image, logically there is no way to import or categorize column it within a table. So a no for Date 5 for me.
IMO: Data 1 and 3.
https://community.powerbi.com/t5/Power-Query/which-all-i-am-allowed-import-in-power-bi/td-p/688716
You have to look for size of file also. Anything greater than 1 GB is not allowed. So considering file size only Data-1, Data-3 and Data-5 are eligible.
Now seems that Microsoft OneDrive works with Excel so Data-3 is out of race.
Why Correct answer is “AE” ? how jpg might be dataset ?
I think the answers should be C and D.
Excel (.xlsx, xlxm) – Excel is unique in that a workbook can have both data you’ve entered into worksheets yourself, and you can query and load data from external data sources by using Power Query (Get & Transform in Excel 2016) or Power Pivot. You can import data that is in tables in worksheets (the data must be in a table), or import data that is loaded into a data model. To learn more, see Get data from Excel.
Power BI Desktop (.pbix) – You can use Power BI Desktop to query and load data from external data sources, extend your data model with measures and relationships, and create reports. You can import your Power BI Desktop file into your Power BI site. Power BI Desktop is best for more advanced users who have a good understanding of their data sources, data query and transformation, and data modeling concepts. To learn more, see Connect to data in Power BI Desktop.
Comma-Separated Value (.csv) – Files are simple text files with rows of data. Each row can contain one or more values, each separated by a comma. For example, a .csv containing name and address data can have a number of rows where each row has values for first name, last name, street address, city, state, and so on. You cannot import data into a .csv file, but many applications, like Excel, can save simple table data as a .csv file.
For other file types like XML Table (.xml) or text (.txt) files, you can use Get & Transform to query, transform, and load that data into an Excel or Power BI Desktop file first. You can then import the Excel or Power BI Desktop file into Power BI.