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