Forum Discussion

whereismydata's avatar
whereismydata
Resolver IV
6 years ago
Solved

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-directqu...
Azure
Power Bi reports server
whereismydata's avatar
whereismydata
Resolver IV
6 years ago

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

d_gosbell's avatar
d_gosbell
Super User
6 years ago

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's avatar
    whereismydata
    Resolver IV
    6 years ago

    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's avatar
      d_gosbell
      Super User
      6 years ago
      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.