HOTSPOT
-
You have a folder that contains 50 JSON files.
You need to use Power BI Desktop to make the metadata of the files available as a single dataset. The solution must NOT store the data of the JSON files.
Which type of data source should you use, and which transformation should you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
The answer is correct ! - Folder - Delete the Content column
buddy you will not be able to see the meta data if you don't expand the attribute
I think she is right because the solution says you should get the metadata and "solution must NOT store the data of the JSON files". You won't satisfy the second part of the question till you delete the content column first.
I agree with you, but this question is a little hypothetical. Assume that the table has 5000 columns, what would you prefer the first step to be? Option 1: -Expand attribute column - Delete content column In this case, after expanding, you'll have to scroll a lot to the left, little tough, and then delete content column, end result would be storing metadata. Option 2: - Delete content column -Expand attribute column This is most preferable, as you'll see content column in the first column position, delete it and then expand attribute column, end result would be storing metadata. I'd still go with option 2 in terms of ease. My answer would be "Delete content column" for 2nd question.
I tested it. The correct answer is 1) Folder 2) Expand the Attribute column. I tested with Deleting the Content column and without deleting it, in both cases the content is not visible when you load the data in Power BI Desktop. In order to see the full metadata you should expand the Attributes column.
I saw video and the answer is - Folder - Combine the files of Content column https://www.youtube.com/watch?v=8GlwDTk5rps&ab_channel=GlobalTechLearn
you saved my time , god bless you dear
The answer is incorrect ! - Folder - Expand the attribute column Done this in Power BI Desktop
Data source type: Folder Transformation: Delete the Content column. This approach will allow you to access the metadata for all the JSON files in the folder without importing the actual data from the JSON files into the dataset.
Tested - it's folder, expand attribute. There are no contents in the file in the data pane, only attributes. This is because the column is 'binary'
The thing here is that the question is not about the order or de number of actions hat you have to follow in order to achieve the solution. The question is,"which action you have to perform?", so independently of the order, you are going to have to delete the content column. So the answer given is correct.
To get METADATA (and not JSON data) I would get data from FOLDER , EXPAND the Attibute column and DELETE the Content column
The answer is correct ! - Folder - Delete the Content column
I tested and the correct option is to "Expand the Attribute column". The "Content" column is automatically removed when we close the PowerQuery. But if we don't click "Expand the Attribute column" we loose these information.
İmage is not shown?
I believe the correct transformation steps would be : 1. Expand attributes 2. Delete content 3. Combine files, getting just 1 table with metadata