topic Re: Azure SQL OAUTH || Power BI Dataflows in Report Server

Azure SQL OAUTH || Power BI Dataflows

whereismydata — Thu, 21 Nov 2019 10:26:52 GMT

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!

Re: Azure SQL OAUTH || Power BI Dataflows

whereismydata — Mon, 25 Nov 2019 11:25:25 GMT

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

Re: Azure SQL OAUTH || Power BI Dataflows

d_gosbell — Wed, 20 Nov 2019 10:51:17 GMT

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.

Re: Azure SQL OAUTH || Power BI Dataflows

whereismydata — Thu, 21 Nov 2019 10:27:54 GMT

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?

Re: Azure SQL OAUTH || Power BI Dataflows

d_gosbell — Thu, 21 Nov 2019 10:50:03 GMT

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.

Re: Azure SQL OAUTH || Power BI Dataflows

mpsrshl — Sun, 24 Nov 2019 22:11:01 GMT

long lasting constraint

https://community.powerbi.com/t5/Report-Server/Organizational-account-credentials-from-Power-BI-Server/m-p/846244#M12165

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

Re: Azure SQL OAUTH || Power BI Dataflows

whereismydata — Mon, 25 Nov 2019 10:20:21 GMT

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.