PowerBI Dataflows connector using a DirectQuery not working

[Anonymous]

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 mode are used. Just simply 1:1 load. The report is working fine in PowerBI Desktop. However when I publish it into the PowerBI Service, it returns an Error: 

Unable to convert an M query in table 'Table_Name' into a native source query.

I figured out that the issue only appears when we are using connector PowerBI Dataflows. Once I use Dataflows it is working fine. However I guess that PowerBI Dataflows was working fine till the last week. Are there any news why the PowerBI Dataflows connector can not be used with the DirectQuery mode? Is it a bug or it is a standard behaviour? 

Thank you for your community support! 
Regards!

[leclercj]

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.

[Anonymous]

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.

[FredAlvesJF]

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

[Anonymous]

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]

Hello @MAwwad ,
thanks for answering. There are no transformations in my PowerQuery. There are just two PowerQuery steps - Source (PowerBI.Dataflows) and Navigation which are returned by default using the PowerBI Dataflow connector. The same Dataflow but with Dataflow Connector (PowerPlatform.Dataflows) is working fine using DirectQuery. 

That is also the reason why I am thinking there has been released some change in PowerBI Dataflow connector. But It is only my guessing.

[MAwwad]

The error message you are receiving suggests that there may be a problem converting an M query used in your report into a native source query when using PowerBI Dataflows as a source in DirectQuery mode. This could be caused by a variety of factors, such as an unsupported function or syntax in your M query, or an issue with the Dataflows connector itself.

You can try to troubleshoot this issue by reviewing your M query code and checking for any errors or unsupported functions, as well as verifying that the Dataflows connector is up to date and properly configured. You may also want to reach out to the PowerBI community or support team for additional assistance or to report a potential bug.