Forum Discussion
Adding measure while using SSAS tabular datasource corrupt the whole report
I have now created an issue with this bug, if you want to support it to give it some attention please give it a vote up:
Just for a quick checkpoint: I've downloaded the files on the bug report, restored the database and used the Power BI file 20181004_ReportMeasures_4_TestReportWithReportMeasureDirectSSAS.pbix on the latest version of Power BI optimized for Report Server, as well as the latest cloud version. Everything ran fine here.
The difference is that my environment is running with the latest PBIRS version ( 2.61.5192.641 64-bit (August 2018)) and also my SSAS is 14.0.204.1 (SQL 2017 CU5) - It is not the last CU because of a bug on SSAS from CU6 that closes a connection when updating the model...lol...
Nevertheless, version June 2017 is not supported anymore.
My thoughts here after reading sdjensen post: It should be an SSAS problem. Did you try to use SQL Server Profiler to trace your queries on the SSAS side and check if it gives you some error message?