Forum Discussion
Power bi connect to dataflow gen2
Hi Aomran ,
To provide more clarification on Dataflow Gen2:If you just define your transformations in a Dataflow Gen2 and save it without writing the data to a destination (like a Lakehouse table or Warehouse), you're not actually persisting the data anywhere.
That means Power BI Desktop can't connect to it because there's no actual dataset to pull from.To make the data available to Power BI Desktop, you need to output your Dataflow Gen2 to a destination.
This could be a Lakehouse , Warehouse or Datamart. You must store the output of a Dataflow Gen2 somewhere.
I hope this helps!
If you think this answered your query, consider marking this post "Accept as Solution".
This will help other users to find the solution more quickly.
Thank You
Let me tell you what's excatly I'm doing!
My understadning is, no need to store the data before consume it by power bi desktop, right?
So, I have dataflow gen2 without publish the data to anywhere! Just ingest the data from the source system and save the dataflow! In the power bi desktop, I've got the above error when trying to load data from dataflow!
Please let me know if it's not option to load data from dataflow without store it in lakehouse or wharehouse!
Thanks