0 Kudos

May 2017 Update - Report level measure on SSAS live connection causes model errors until reprocessed

Status: Delivered
by hitzand Regular Visitor on ‎06-01-2017 05:23 PM

A couple of weeks ago we noticed issues with multiple reports using live connection to a particular SSAS Tabular model.  Some measures in them would start returning an Unexpected Exception, or sometimes spin until the server ran out of memory, but other times were fine. We went crazy trying to figure out if the issue was in the reports, model, gateway, or SSAS server configuration.  Eventually we determined the following was happining:

 

A new report using a live connection to the model had been built, and since we needed a custom measure for this particular department, we had used the new report level measures.  It turns out that refreshing this particular report with the new measure in it would cause some other measures in the model to return "Unexpected Exception" for all future queries, whether they were from Power BI reports, Excel workbooks, or SSMS queries.  Reprocessing the model would correct the issue, until the next time that particular report was refreshed.  

 

We removed all report level measures from the report and no longer see the issue, but obviously are not going to use report level measures again until this issue is resolved.

Status: Delivered
Comments
by Moderator v-qiuyu-msft
on ‎06-04-2017 11:05 PM

Hi @hitzand,

 

I’m not reproduce the issue on my side, please check below things:

 

1. There are several May desktop versions, please make sure the one runs in your environment is the newest version 2.46.4732.721.


2. Please check if the issue related to the tabular data model. You can connect live to the Adventure Works Internet Sales Tabular Sample Database here, and create a report level measure like below:

 

Measure 2 = CALCULATE(SUM('Internet Sales'[Sales Amount]),FILTER(ALL('Product'),'Product'[Product Name]="LL Road Tire"))


3. Please enable the desktop trace log, repeat the steps to create the report level measure and refresh, Share the trace log files with us.

 

Best Regards,
Qiuyun Yu

by Vicky_Song Established Member
on ‎06-04-2017 11:06 PM
Status changed to: Needs Info
 
by hitzand Regular Visitor
on ‎06-06-2017 09:41 AM

@v-qiuyu-msft:

 

 

1. This is definitely on 2.46.4732.721 

2. I checked against AdventureWorks.  I can't recreate the problem with that model. 

3. I've recreated the issue with our report and model while doing a trace log.  Logs, detailed steps taken, and the pbix are here.

 

by Moderator v-qiuyu-msft
on ‎06-07-2017 03:09 AM

Hi @hitzand,

 

The issue should be related to your SSAS tabular server. I would suggest create a support ticket to get dedicated support from Miscrosoft engineer.

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu

by Vicky_Song Established Member
on ‎06-07-2017 03:09 AM
Status changed to: Delivered
 
by GB31 New Member
on ‎09-04-2017 11:48 PM

Hi @hitzand, we are facing the same issue. Do you still have this issue? If not, how did you resolve it?

by JAkerblom Frequent Visitor
on ‎10-03-2017 01:58 AM

I came across this bug in my company as well. Spent weeks debugging the underlying SSAS cube without even thinking about the possible fact that it was PowerBI that had a bug. The thing with what I'm experiencing is that it is not my created measures that cause elements to crash, it is the base measures that are used in those created measures that suddenly stop working. 

 

E.g. I have [Amount] from the cube, but want a [Amount < 100] measure with a simple filter on the base measure [Amount]. With this done, the [Amount < 100] works fine, but 10mins after implementing this suddenly one element after another start crashing. The weirdest part is that not all elements crash, just some of them.. 

 

I see that this is almost considered an old post, but what I'm experiencing sounds a lot like what you describe. Has this not yet been fixed? 

by hitzand Regular Visitor
‎10-03-2017 06:19 AM - edited ‎10-03-2017 06:23 AM

@JAkerbl @GB31 This does sound like what we experienced.  The affected fields/measures are not consistent.  Sometimes one calculation would get broken, sometimes another.   We never got any confirmation that it was actually fixed.  We stopped using report-level measures on SSAS models.   

 

The troubling thing with this issue is that potentially an end user could create a report that breaks the model for everyone else.

by JamesBI Regular Visitor
on ‎10-26-2017 12:06 PM

We had this same issue and we were able to resolve it by installing CU5 on our SSAS server.

Idea Statuses