Forum Discussion
Power BI Service - Publishing report
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.
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.