may 2019
1 Topic
PowerBI RS May 2019 Desktop - Error Deploying to SSRS DirectQuery
Hi, I have found a problem (I think) in the May 2019 edition of PowerBI Desktop for Report Server. When I deploy a report created in January 2019 edition that uses DirectQuery to a SQL Server data source, it works fine. It deploys to SSRS, and I can run the report and produce the expected results. If I take that pre-existing report, open it in May 2019 edition, and deploy the same report to SSRS, again, it works as expected, and the report data loads and refreshes without issue. If I create a brand new pbix file in May 2019 edition with DirectQuery to the same SQL Server data source using the same query, create an identical report to the previous where the only difference is that it was created entirely in May 2019 edition of PBI, then deploy to the SSRS server, I get the following error: Both reports are set up to use the windows authentication credentials of the user viewing the report, but the Jan 2019 created version of the report works, and the May 2019 version produces the error captured above. Does anyone know what might have changed in the May 2019 PBI Desktop edition that might cause this? Is this intentional, or a bug? For now we have reverted back to January 2019 edition but I would like to know if this can be solved. Can anyone else reproduce? Thanks, -J.Solved9KViews1like9Comments