Forum Discussion
Dataflow showing empty tables in Power Bi desktop
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 sh...
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.