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.
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.
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.
@ImkeF @edhans ?
Proud to be a Super User!
View solution in original post
Thanks. Yes I tried to do for few times, and now I can preview and load the data from my dataflow via PBI desktop.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.