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

Anonymous — Thu, 31 Aug 2017 14:13:33 GMT

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

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

v-qiuyu-msft — Mon, 04 Sep 2017 12:54:14 GMT

Hi Anonymous,

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

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

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

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