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.
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