Forum Discussion
Adding measure while using SSAS tabular datasource corrupt the whole report
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?
Hi muchinski,
I don't know what you are refering to with June 2017?
You are using SQL2017 and yes, I have no issues with this feature on a SQL2017, this issue is related to SQL2016 and I can't find anywhere in the documentation, that this feature requires SQL2017 or a certain build of SQL2016 - I will be more than happy to test on a SQL2016 SP2 (or later since SP2 had a bug related to SSIS), but I need more space on my test server before I can upgrade it.