Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have dataflow with in total 10 Entities on a Premium account.
I am having trouble with tables showing data in Dataflow but they are empty in Power Bi Desktop.
All marked with bold shows data in Power BI Desktop.
Entity1: loads and combines .xslx files from a Sharepoint folder. - currently 3 files about 9 mb in size each
Entity:2 Manually entered data
Entity3: load data from Excel sheet in Sharepoint folder and merge with Entity2
Entity4: Use Entity3 as reference and replace values and unpivot
Entity5: Use entity1 as Reference, merge with entity3 and make calculations
Entity6-9: Use entity1 as Reference, merge with entity3 and make calculations - Similar setup as Entity5 but with different calculations
Entity10: Combines Entity5-Entity9 - In Power Bi Desktop it is only showing data from Entity5.
In all entities I can see data in the Dataflow when editing in the Web.
I cannot figure why entity6-9 is somehow different from Entity5.
I am not getting any error messsage in either Power BI Desktop or Dataflow.
Can you help out?
Br
Jakob
Hi @jskipper
You might refer to these similar posts:
https://community.powerbi.com/t5/Service/Data-flow-showing-empty-data/m-p/890971
If still not help, please kindly raise it to the support team for better advice:
https://powerbi.microsoft.com/en-us/support/
Which error messages do you have under settings in the dataflow "refresh history"?
Best,
Kathrin
Sound like a weird problem... I used also Sharepoint and it works fine. Do you try to rebuild the dataflow? (probably already done) Best, Kathrin
Yes. It is actually the rebuilt version as the other one did not refresh.
I have done a lot of trial and error with Dataflow and I must say that I feel the product is very inmature. In general in the development I have had many different error messages. I think it is very frustrating that you can not simply copy and paste the code from Power BI Desktop and then it just works but there is always a need to make corrections. Mayde due to the flow is combining files from Sharepoint.
I am missing my great experience with Alteryx that is much faster and better to do data transformations. Unfortunately I do not have that option at the company I am at currently.
Fun Fact: there is a way you can actually copy and paste the code from power query advanced editor and put it into blank query in dataflow. XD But I don't know If this will solve your problem.
But I musst agree the dataflow is not conviniende - also the refresh of the report must triggered by a power automate.
Best,
Kathrin
I am aware that you copy code from PQ advanced editor becuase this is how I did it, but I copied the code bit by bit as I was getting all kinds of error messages if I toke the full code. I believe it would be much simpler to do if I did not have to combine files from a Sharepoint folder, which mean it was 3-4 additional queries to make that work.
I do not get an error message.
Data is also available when looking in the Dataflow.
Thanks for sharing but I had already seen these threads but without any luck.
Br
Jakob