cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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.

jenniferho_1-1599719919362.png

 

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.

jenniferho_2-1599719999293.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

@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  ?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

@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  ?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors