Error: Unable to convert an M query...

[Anonymous]

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: 

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.

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

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

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.

[amitchandak]

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

[Anonymous]

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:

Thank you.