search

migueesc123 / PowerBIRESTAPI

A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API
MIT License
237 stars 74 forks source link

Conditional Access Policy Blocks API use #174

Closed Rich-at-Chester-Business-Analytics closed 1 year ago

Rich-at-Chester-Business-Analytics commented 1 year ago

Good morning,

My company implemented a Conditional Access Policy as follows:

Targets: All Users Target Resources (cloud apps): Power BI, Power BI Service Grant control: Require device to be marked as compliant, Require Hybrid Azure AD joined device (Require one of these controls).

Once that was implemented I can no longer refresh my dataset using the API. The error I get is Invalid Credentials.

Interestingly I can initiate a new connection, select a table, see a preview... but when I save the query I am asked to login and get the invalid credential error... so it appears that running from the query uses a different access method than creating/refreshing the query does (I'm guessing).

Any ideas on what I could modify in the policy to allow the API to continue to function?

Thank you!

RIch

migueesc123 commented 1 year ago

I think this might go beyond what we can answer as the developers of the connector and this might fall more into what the Power BI REST API team would be able to answer. I'm converting this into a discussion hoping that other members of the community could potentially provide any insights into this.