Azure SQL OAUTH || Power BI Dataflows

[whereismydata]

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!

[whereismydata]

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.

[mpsrshl · Accepted solution]

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. 

[whereismydata]

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

[d_gosbell]

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]

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?

[d_gosbell]

---

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