cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
whereismydata Regular Visitor
Regular Visitor

Azure SQL OAUTH || Power BI Dataflows

Hi,

 

I need to connect to a Azure SQL db via Oauth. This is, according to https://docs.microsoft.com/de-de/power-bi/report-server/data-sources#list-of-supported-authenticatio... not possible.

edit: currently no solution....

 

I tried setting up a Power BI Dataflow on one of my premium workspaces, but Power BI RS does not identify the source.

 

Is there anyway I can refresh the data via Power BI RS and using Azure SQL db?

 

Why can't I connect to Dataflows via Power BI RS?

 

thank you very much!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
mpsrshl Regular Visitor
Regular Visitor

Re: Azure SQL OAUTH || Power BI Dataflows

long lasting constraint 

 

https://community.powerbi.com/t5/Report-Server/Organizational-account-credentials-from-Power-BI-Serv...

 

Microsoft hasn't allowed us set up organizational accounts in he PBIRS yet. 

View solution in original post

6 REPLIES 6
whereismydata Regular Visitor
Regular Visitor

Re: Azure SQL OAUTH

Does no one use Power BI RS with Azure SQL as source?

Super User
Super User

Re: Azure SQL OAUTH

No, the documentation link you posted in your first post is still correct. The only authentication method PBIRS currently supports against Azure SQL is username/password.

whereismydata Regular Visitor
Regular Visitor

Re: Azure SQL OAUTH

Hi @d_gosbell , thank you for taking time to look at my problem. Any change you know why Power BI RS can't connect to Dataflows?

Super User
Super User

Re: Azure SQL OAUTH


@whereismydata wrote:

 Any change you know why Power BI RS can't connect to Dataflows?


No I have no idea.

 

But if I had to guess I'd say it's probably because one of the primary use cases for Power BI RS is when organizations have restrictions preventing them from putting data in the cloud. If you are using dataflows your data is already in the cloud so using the Power BI service would seem to be a better choice as the cloud service is always going to have more features and functionality than the on-prem version.

mpsrshl Regular Visitor
Regular Visitor

Re: Azure SQL OAUTH || Power BI Dataflows

long lasting constraint 

 

https://community.powerbi.com/t5/Report-Server/Organizational-account-credentials-from-Power-BI-Serv...

 

Microsoft hasn't allowed us set up organizational accounts in he PBIRS yet. 

View solution in original post

whereismydata Regular Visitor
Regular Visitor

Re: Azure SQL OAUTH || Power BI Dataflows

Hi @mpsrshl  and @d_gosbell ,

 

Well, some data is on prem and some data is in the cloud. So, I don't want to move data to the cloud but pull data from other sources and combine with local data.

 

Indeed, Power BI Service has some neat functionalities, but I do see some benefits of PBIRS.

 

I’ll have to wait then.

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,006)