Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unable to convert M query into Native Query

Hello,   We are facing dataset connection issue only on Training environment whereas reports are working fine for all the other environments. This error is also not consistent, it is appearing for ...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

Would you please try to use the latest verison of power bi desktop and republish the report to web service again.  Please check the applied steps in query editor.

 

As the document says:  If the Query Editor query is overly complex, an error occurs. To remedy the error, either delete the problematic step in Query Editor, or import the data instead of using DirectQuery. 

 

For more details,  please refer to the similiar post: https://community.powerbi.com/t5/Desktop/Error-Unable-to-convert-an-M-query/m-p/1401998 and https://community.powerbi.com/t5/Service/Unable-to-convert-an-M-query-in-table-table-name-into-a-native/m-p/1550219

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
5 years ago

My query is not complex. There are just 2 steps source and Navigation. But I can try by installing latest Power BI desktop.

 

Thanks for your support.

 

BR,

Pravina