cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EmaVasileva
Helper IV
Helper IV

Error: Unable to convert an M query...

Hi all,

I'm having a dataset connected to a SQL Server/Direct Query and until today everything worked fine. Today, when I opened the advanced query of the one table, I received the following error: 

MicrosoftTeams-image.png

 

 

 

 

 

 

If I try to make any changes to the dataset,even a simple calculation, the dataset can't be published/refreshed successfully to PBI Service.

Any ideas?

Thank you.

1 ACCEPTED SOLUTION
v-zhenbw-msft
Community Support
Community Support

Hi @EmaVasileva ,

 

Please open the Power Query Editor, click the FactTasks table, check the applied steps on the right.

 

error1.jpg

 

Keep only the first and second steps. Then close and apply, check the visual again.

 

It may be that Direct Query does not support some of your conversions.

 

If it doesn’t meet your requirement, could you provide more screenshots in detail?

 

Best regards,

 

Community Support Team _ zhenbw

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

View solution in original post

3 REPLIES 3
v-zhenbw-msft
Community Support
Community Support

Hi @EmaVasileva ,

 

Please open the Power Query Editor, click the FactTasks table, check the applied steps on the right.

 

error1.jpg

 

Keep only the first and second steps. Then close and apply, check the visual again.

 

It may be that Direct Query does not support some of your conversions.

 

If it doesn’t meet your requirement, could you provide more screenshots in detail?

 

Best regards,

 

Community Support Team _ zhenbw

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

View solution in original post

amitchandak
Super User IV
Super User IV

@EmaVasileva , What are the changes you have done to FactTask3?



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi @amitchandak,

We make a few data tranformations in Fact Tasks (3) - like unpivoting, column duplicate, filtering data our, etc. 

 

Up until now, we did not have any issues neither making additional changes to the dataset nor refreshing it online.

 

Now we tried to add a new measure field with IF('Time'[Date]=TODAY()-1,"Yes","No") calculation in another table (not Fact Tasks (3)) and there is the mistake.

 

Also, now I have this warning in all the tables in Advanced Query:

MicrosoftTeams-image (1).png


Thank you.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors