Forum Discussion

Aomran's avatar
Aomran
Frequent Visitor
1 year ago
Solved

Power bi connect to dataflow gen2

Hi all,   I'm trying to connect power bi desktop to dataflow gen2, and I have this error!   The dataflow has no error in the workspace, and I have access! Your response is really appreciat...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    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

Aomran's avatar
Aomran
Frequent Visitor
1 year ago

Thanks for your clarficaition, I'm not storing the data because no need for that, and to minimize the cost!

So in theory, I should be able to consum data from df gen2, but I've got the above error!

The connector is dataflows in power bi desktop, I've tried the first and last one!