Forum Discussion
DAX Query View
- Anonymous1 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.
- 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.
Hi
I have checked I am definitely only using the Report Server version 2.129.2203.0 64-bit (May 2024). Just adding a new page to DAX Query view and saving creates the same 'Unable to save document' message. If I don't use DAX Query view and then edit the document and save document there is no issue. It is real shame because I really like using the DAX Query view feature.
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.