Forum Discussion

Dars's avatar
Dars
Frequent Visitor
8 years ago

Adding measure while using SSAS tabular datasource corrupt the whole report

Hello,   We have Power BI Server installed locally.  We are using Power BI for Desktop optimized for Power BI Server (June 2017 version).  We ran into some issues while creating report using an SSA...
Power BI Report Server
SSAS
sdjensen's avatar
sdjensen
Solution Sage
7 years ago

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.

sdjensen's avatar
sdjensen
Solution Sage
7 years ago

Dars

 

I have now found a solution - I upgraded my SQL2016 to SP2 which solve the problem, I did however have to upgrade to SP2 CU3 to have a full working solution. SP2 have a bug with processing Analysis Services models from SSIS.