Forum Discussion

jskipper's avatar
jskipper
Frequent Visitor
6 years ago

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...
Dataflow
Need Help
jskipper's avatar
jskipper
Frequent Visitor
6 years ago

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.

KBO's avatar
KBO
Icon for Memorable Member rankMemorable Member
6 years ago

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

  • jskipper's avatar
    jskipper
    Frequent Visitor
    6 years ago

    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.