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.