unable to see any transformed data in PowerBI desktop when get data from dataflow (json files)

[jenniferho]

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.

[Greg_Deckler · Accepted 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  ?

[jenniferho]

Thanks. Yes I tried to do for few times, and now I can preview and load the data from my dataflow via PBI desktop.