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

parry2k's avatar
parry2k
Icon for Super User rankSuper User
1 year ago

Aomran although if you don't send the output of dataflow to lakehouse/warehouse, it still stores the processed data. Best practice with df gen2 is to store the output to a lh/wh but if you are not storing it into the lh/wh, you can still connect to the dataflow and should be able to get the data from df gen2. Once you are connected to df, you should see the tables instead of SQL server. What dataflow connector are you using?