Unable to convert an M query in table

[mmowrey]

I have this report that works fine with desktop but when I push to web, i get this error..

 

Couldn't load the data for this visual

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

Please try again later or contact support. If you contact support, please provide these details.Hide details

• Activity IDe5a8f3bb-b4f1-4a05-954c-061db9c78f75
• Request ID5a836353-73b1-eca0-19ea-f9a6f1075d51
• Correlation ID8666fdbd-4403-e15a-a546-f82d1dace451
• TimeWed Dec 07 2022 11:06:28 GMT-0500 (Eastern Standard Time)
• Service version13.0.19491.58
• Client version2211.2.11230-train
• Cluster URIhttps://wabi-us-east2-b-primary-redirect.analysis.windows.net/Copy

[v-tangjie-msft]

Hi @mmowrey ,

Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

Best Regards,

Neeko Tang

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

[v-tangjie-msft]

Hi @mmowrey ,

If you are using directquery in this report, for some transform is not support, you have changed it to import.

Open the Power Query Editor, click Table, and check the steps applied on the right. Only the first and second steps are kept. Then close and apply to check the visual again.

You can also refresh a report in the latest version of Power BI Desktop and publish the report to the Power BI service.

You can refer to the following posts that may be helpful to you:

Solved: Power BI Service - Publishing report - Microsoft Power BI Community

Solved: Unable to convert an M query in table [table name]... - Microsoft Power BI Community

Best Regards,

Neeko Tang

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