Forum Discussion
Power BI Service - Publishing report
I have set up my dashboard in Power BI desktop and after publishing it then in some charts I get this message : "Unable to convert an M query in table XXX into a native source query. Please try again later or contact support." Has anyone have any idea why is this happening? Thank you
Hi Paul
Thank you for your answer.
I am using Direct Query mode... indeed actually I changed my table back to its initial state and then the chart I tried to create worked fine! So , I guess the issue here is when I am trying to change an initial table , l mean a column like "deleting" any gaps between numbers or texts , or using a formula in M language like "Test.Start" , such things can be tricky enough to make a visual afterwards not work. Thanks again for your answer.
2 Replies
Kergofil
Which datasource and which connection mode did you use? Becausue live connection mode doesn't support m query transformations, e.g. "unpivot columns". You need transform in orginal data source.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.Hi Paul
Thank you for your answer.
I am using Direct Query mode... indeed actually I changed my table back to its initial state and then the chart I tried to create worked fine! So , I guess the issue here is when I am trying to change an initial table , l mean a column like "deleting" any gaps between numbers or texts , or using a formula in M language like "Test.Start" , such things can be tricky enough to make a visual afterwards not work. Thanks again for your answer.
