The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We have an OData Application that we've build to allow our customers to access their data with the intentions of making it available to Power BI.
Our API is configured to use Azure AD B2C Authentication. While all of this works in Postman and other general testing tools, when we actually attempt to use Power Query (via Excel or Power BI) and we're getting a "The token service reported by the resource is not trusted." error.
In my research I found that apparently Power BI is unable to use OAuth unless it's a first party API endpoint? But then I also found even with even more research a post indicating that it did support 3rd Party OAuth endpoints. So now I'm just confused, and needing confirmation one way or the other.
If it can't support Azure AD B2C, would it maybe work with the Customer Tenant system in preview?
Hi, @mattke2b
how about using B2B then add client as guest users? Also tenanct setup is associated with MS azure ID, I am not sure using perview in clients tenant will workin your case.
if this doesn't help then I suggest you reach out to the support.
Proud to be a Super User!
In the end we just dropped the OAuth2 component of our OData API. The entire purpose of using B2C was/is specifically to keep the guest user count down at as close to zero as possible. We simply do not want our customers accounts in the same tenant we manage and control infrastructure.