Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PowerBI Dataflows connector using a DirectQuery not working

Dear PBI Community, we have a trouble with reports built upon a DirectQuery Datasets using PowerBI Dataflows as a source. We do not use any advanced transformations when the Dataflows in DirectQuery...
Dataflow
Need Help
leclercj's avatar
leclercj
New Member
3 years ago

Hello Anonymous 

I faced exact same issue yesterday. After investigation today, I found that tables in trouble in my dataset were built several months ago using what is now named "Power BI dataflows (Legacy)" connector.
I redefined them using the new Dataflows" connector, and it actually fixed the problem.

 

  • FredAlvesJF's avatar
    FredAlvesJF
    New Member
    3 years ago

    You did is manual? There is some way to change for all?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I am not sure there is a automatic way how to fix it. In your PowerQuery transformation you have to modify 1st step - Source. You have to change PowerBI.Dataflows for PowerPlatform.Dataflows. Then you have to navigate to the dataflow you would like to connect. And the steps for selecting the dataflow which are evaluated through PowerPlatform.Dataflows are not the same like in PowerBI.Dataflows connector.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Yes, exactly this is what I also figured out! I am glad that I am not the only one who had this exact issue. I know that Power BI dataflows connector is in Legacy, but there had to be change on PowerBI Service last week. Because all our solutions based upon this connector  with DirectQuery has started to fail since this week.