Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Aim: get SSRS reports working in PowerBI service.
So far: I have a couple of SSRS reports which can run on my laptop. I can currently connect them (in Visual Studio) to the Azure DB with AD password Auth and the reports run. I have uploaded them to PBI service. Update: I have tried using ODBC connection, but PBI service does not support that.
However, I can not get them to access the Azure DB from PowerBI service. The first thought it might be a firewall issue and turned "Allow Azure services on". The Error message is: Cannot open server "_____" requested by the login. The login failed. Status 400.
One thing to note, the authentication method in PBI service only allows basic connection.
Are there any other suggestions?
Solved! Go to Solution.
Well, the library for Report Builder should support AAD auth with a proper auth prompt like it does for Azure Analysis Services, or we'll make sure it does when we do this work to support it. We have to implement the auth support independent of what is currently supported for PBIX, since the way data sources are used is different betweent the report types. We're planning to add this support in near future.
Does the report run/open in Power BI Report Builder? Is IP filtering enabled for the Azure SQL db? Are you using any features in the report that might not be supported currently (subreports, for example)? Wondering if it is just a misleading error message
Also might try using SQL Server creds if that works. Want to make sure we narrow it down properly.
@chrisfinYeah, I think using a SQl database connection may be the option, one the customer doesn't want to use unfortunatly.
@v-yuta-msftI am not sure what you are refering to? My guess is that you are suggesting using AD universal - MFA connection. Which, based on my understanding, is not the same as AD password.
My current undestanding is that it is an authentication issue:
Report Bulider only supports> windows & SQL server
Visual Studio SSDT supports> windows, SQL server, AD intergrated & Ad password
PowerBI supports> windows, database (SQL server I assume) & microsoft sign in (AD - universial with MFA i assume)
I think the plan is to use a gateway at somepoint, my guess would be once that is set up them maybe windows/SQL server authication methods would be an option. However, I am very new to this.
Well, the library for Report Builder should support AAD auth with a proper auth prompt like it does for Azure Analysis Services, or we'll make sure it does when we do this work to support it. We have to implement the auth support independent of what is currently supported for PBIX, since the way data sources are used is different betweent the report types. We're planning to add this support in near future.
@Anonymous ,
Use https instead of http in the URL of azure db server and check if this issue persists.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.