Forum Discussion

trevorh909's avatar
trevorh909
New Member
1 year ago
Solved

DAX Query View

Power BI Desktop (RS):  Version: 2.129.2203.0 64-bit (May 2024) After using DAX Query View I am unable to save changes back to the Report Server and I receive this message: 'Unable to save document'...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, trevorh909 

    Not being able to upload to a report service after using DAX Query view seems to be a limitation. Perhaps you can skip the feature for a while and use a different approach to the same query and analysis. For example, using DAX Studio is a powerful tool for writing and debugging DAX queries. You can write queries in DAX Studio. 

    I create a sample table in Power BI Desktop(RS):

     

    Then open DAX Studio, It will automatically detect the PBIX file you have opened

     

    Connect it, and use DAX query:

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

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

  • trevorh909's avatar
    1 year ago

    Thank you for the solution but I don't think it will work in my case though, because I run PowerBI Report Server as a remote application to connect to the on premises servers, but I appreciate that would work if I were not running the application this way, so I will accept the solution. I hope in future updates to Power BI report server version will resolve this issue with the bug when usisng the DAX query view.