Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Test Connection Broken

Hi,   I've been setting up Kerberos authentication and changing the service account running PBIRS. Now when I click "Test Connection", from the Data Sources screen of report managment, it fails eve...
Data Source
Report Server
GDAN's avatar
GDAN
Frequent Visitor
8 years ago

Hi,
we have the same issue since  PowerBI-Server update from March2018.

Only for the Power BI Reports.

kieranW's avatar
kieranW
Advocate I
8 years ago

We have the same issue. We have a report published to the server with SSAS Tabular 2016 in Direct Query mode as the data source. The SSAS Tabular model in turn has a Direct Query connection to the underlying SQL Server DB, where we are applying user based row level security. The report was working fine until this weekend, although I did notice the "Data source AnalysisServices is not supported." message when I clicked on Test Connection. Now the report has stopped working completely. I have tested this with some of the end users and have established the following:

 

- They are able to connect to the SSAS cube as expected via Excel, and can view the data they are supposed to (i.e. everything is working properly)

- When they try and view the report in PBI Report Server, the report opens but each of the visuals fails with an error message saying they have insufficient permissions

- I tried creating a completely new report using PBI Desktop on one user's own machine, with the SSAS cube as the data source. He was able to connect to the cube but again got a permissions error when trying to view any of the data in PBI Desktop.

 

Has there been any update from Microsoft on this? The report is business critical and I don't have a viable solution at this point.