Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I got a bunch of json files as data source located in my PC.
1 json file is holding 1 xapi statement.
My purpose is to create a dataflow, then do all the data transformation there. Go to PowerBI desktop, get data from the data flow to further create report.
Steps
1. Create a dataflow with on-premise gateway, use folder method to get the json files located in my local PC.
2. On powerBI service, I do all the data transformation there including, then I saved the dataflow, all looking good.
2.1 expand all the nested json document by (expandContent = Json.Document([Content]))
2.2 rename the atributes
3. Then I have done a manual refresh on the dataflow.
4. On powerBI desktop, get data from the dataflow
However, I cannot see any transformed data inside.
Then I click "transform data".
I found the renamed attributes can be shown, however, I cannot find any data...
I tried to click "refresh preview", but also unable to see any content.
May I ask did I miss anything? Many thanks.
Solved! Go to Solution.
@jenniferho I have seen this kind of thing sometimes when I was messing with dataflows. I would try closing and applying and see if the data comes in or not first.
@jenniferho I have seen this kind of thing sometimes when I was messing with dataflows. I would try closing and applying and see if the data comes in or not first.
Thanks. Yes I tried to do for few times, and now I can preview and load the data from my dataflow via PBI desktop.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.