Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey Guys,
I recently have an issue with dataflow. I have been searching Power BI community to figure out the solution. There is a few topic similar to the one that I have and the answer has been selected as "Solved" but based on their solution I cannot apply to my situation. The solution doesn't work. So, I bring it up again.
Here is the situation,
I am using the data source from Odata to feed to Dataflow and then using Power BI desktop version to collecting the data I have store it in data flow.
Attached 3 pictures help me to explain the situation. I can see the data from Odata in data flow I created, but when I redirect the data from data flow to Power BI desktop version. It gives me all empty tables.
I try with different source file as SQL oracle data source file, everything is fine (in data flow or desktop version).
I am wondering if there is any issue with Odata as source in dataflow. I tried to disconnect the data source and refresh it (doesn't work). Please help. If the Power BI community people see it, could you please check with tech team if there is any problem with their site.
By the way there is a little story when I save the dataflow. Beacuse original data set has a few columns as "table" so there is a error pop up when I put data into Data flow (web). And when I save it, it gives me a error because of "table" type data. And I click ok and save it again, it gets saved without "table" columns(My guess is data flow doesn't accept "table" type of data it gets deleted no problem, I am not using those columns anyways). I am sure if there is anything to do with the situation. Just bring it up.
Thanks in advance!!!!
Solved! Go to Solution.
Hey @v-lionel-msft , After I talked with the support team, we finally get the solution for this issue.
Thank you so much to Melina Costa de Souza! The problem is with refresh!
Attached pic to address where you need to click refresh. Refresh it on the Dataflow (web) right after you save it. Not on the Power BI desktop where you pull the Dataflow into Destktop.
Hi @Anonymous ,
I can't reproduce your problem.
Please create support ticket.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @v-lionel-msft , After I talked with the support team, we finally get the solution for this issue.
Thank you so much to Melina Costa de Souza! The problem is with refresh!
Attached pic to address where you need to click refresh. Refresh it on the Dataflow (web) right after you save it. Not on the Power BI desktop where you pull the Dataflow into Destktop.