cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AaronSC Frequent Visitor
Frequent Visitor

SSRS reports cannot connect to azure DB in power BI Service.

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team chrisfin
Power BI Team

Re: SSRS reports cannot connect to azure DB in power BI Service.

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.

View solution in original post

5 REPLIES 5
Community Support Team
Community Support Team

Re: SSRS reports cannot connect to azure DB in power BI Service.

@AaronSC ,

 

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.

Power BI Team chrisfin
Power BI Team

Re: SSRS reports cannot connect to azure DB in power BI Service.

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

Power BI Team chrisfin
Power BI Team

Re: SSRS reports cannot connect to azure DB in power BI Service.

Also might try using SQL Server creds if that works.  Want to make sure we narrow it down properly.

AaronSC Frequent Visitor
Frequent Visitor

Re: SSRS reports cannot connect to azure DB in power BI Service.

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

 

Power BI Team chrisfin
Power BI Team

Re: SSRS reports cannot connect to azure DB in power BI Service.

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.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 308 members 2,929 guests
Please welcome our newest community members: