cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stpnet
Impactful Individual
Impactful Individual

BUG in deployed SSRS PBIX? when generating measures in the same tabular model in a new PBIX

We have a pretty simple set of reports. We are using DirectQuery to a SQL 2016 Tabular model

 

We have a couple of simple measures defined in the Tab Model. the DAX for these looks like this

 

DAX in tabular model:

 

Tickets Logged:= CALCULATE(SUM('Ticket_vw'[Ticket Count]), USERELATIONSHIP(Ticket_vw[Date Call Logged],Date_Hierarchy_vw[Date]))

Tickets Resolved:= CALCULATE(SUM('Ticket_vw'[Ticket Count]), USERELATIONSHIP(Ticket_vw[Date Call Resolved],Date_Hierarchy_vw[Date]))

 

We link to this using DirectQuery to build a report that can be deployed. We deploy the report. Everything works fine.

 

We edit the PBIX or start a new PBIX and add a measure in Desktop (this is exactly what we expect users to do when they Edit in PowerBI Desktop.

 

DAX in PowerBI

 

Net Tickets = [Tickets Logged] - [Tickets Resolved]

 

Monkey about with this until you get a bad relationship issue

The Desktop edition shows the broken visual

 

Couldn't load the data for this visual
An unexpected exception occurred.
 
OK, fair enough. I did somehting stupid. However if I refresh the SSRS screen with the wokring report open it also now gives me the error. Its not been changed but it now breaks. It breaks even if its a different user looking at it. 
 
This is BAD! something I did in PBI Desktop on my machine has broken a deployed report on the SSRS Server!
 
If I restart the SSAS tabular instance or reprocess the model the SSRS report will start working again. So its somehting to so with caching or possibly an issue at the tabular end
 
I run a set of Extended Event traces on the Tabular instance and run through teh steps again. No error reported in the Extended Events. the traces look the same for a working refresh of the SSRS report as they do when the same report comes back with "Broken"
 
Looking in the RSPowerBI log I see three errors (there are three broken visuals)
 
All of whihc look pretty much like this
 
2017-08-31 15:24:38.8004|ERROR|2213|PBI.DS.HostTrace|type:Error;message:Writing error DSR.Details: Message=Failed to execute the DAX query., HResult=0x80004005, ErrorCode=QuerySystemError, Language=en-US, ProviderErrorCode=0xC1000016, ProviderErrorMessage=[<pi>An unexpected exception occurred.</pi>], ProviderGenericMessage=[Internal error: An unexpected exception occurred.], ErrorSource=PowerBI| RequestID = 61437fcd-2b87-a36e-4fb9-d7d69e7829cc ClientSessionID = 86add49c-b927-d2be-f26f-42395f3c100e
 
can anyone suggest what a next step might be and or what I might adjust to see what can be done.
 
I did wonder if I could adjust the security settings in the PBIX that we were editing but it doesn't show up as a connection in the connection details.
 
regards
 
 
Steve
 
This is all running on one DEV server with admin acocunts for two different devs, so I'm not expecting any permissions issues.
 
This is the GA release running the accompanying GA release version of PBI Desktop, all running agianst SQL2016 SP1
 
 
many thanks
 
Steve
1 REPLY 1
v-qiuyu-msft
Community Support
Community Support

Hi @stpnet,

 

I'm not able to reproduce the issue. Which Power BI report server version did you run? Please try to run the latest version: https://www.microsoft.com/en-us/download/details.aspx?id=55790

 

Do you have any ideas? @mgmeyer @Jon-Heide

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates