Forum Discussion
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-authentication-methods-for-directquery 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!
long lasting constraint
Microsoft hasn't allowed us set up organizational accounts in he PBIRS yet.
6 Replies
Does no one use Power BI RS with Azure SQL as source?
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.
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?
long lasting constraint
Microsoft hasn't allowed us set up organizational accounts in he PBIRS yet.
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.
