Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.