Reply
TerriblyVexed
Frequent Visitor
Partially syndicated - Outbound

Access to the resource is forbidden

I've seen this error explained in many other posts here and across the interwebs; mostly in the context of SharePoint. However none of them seem to be as it pertains FHIR. I have an Azure API for FHIR implemented in my Azure environment. I built and tested several Power BI reports and dashboards against a DIFFERENT FHIR server set up by another team member. It was NOT Azure API for FHIR but rather FHIR on Azure with an App Service. I didn't set this one up. But I did set up the Azure API for FHIR version. After setting my connections in Power BI to this new URL I now cannot read data in my Power BI reports. I can connect, but I get Expression.Error: Access to the resource is forbidden. when trying to read the data. In the Power BI Desktop.

I have made the service multi-tenant.

I have Cleared Permissions as so many of the other posts recommend.

I have tried using a fresh blank Power BI doc.

TerriblyVexed_0-1639413961299.png

 

Any help?

1 ACCEPTED SOLUTION

Syndicated - Outbound

The solution was to add the Organizational Account to FHIR Data Reader RBAC(IAM). This was not specified on the Microsoft documentation. I have asked the program manager to add it.

View solution in original post

6 REPLIES 6
TerriblyVexed
Frequent Visitor

Syndicated - Outbound

I've opened an incident with the Microsoft Health engineer team. EOY being what it is, I don't expect much from them before next year.

Syndicated - Outbound

The solution was to add the Organizational Account to FHIR Data Reader RBAC(IAM). This was not specified on the Microsoft documentation. I have asked the program manager to add it.

TerriblyVexed
Frequent Visitor

Syndicated - Outbound

It is Azure API for FHIR ^^^


@TerriblyVexed wrote:

I've seen this error explained in many other posts here and across the interwebs; mostly in the context of SharePoint. However none of them seem to be as it pertains FHIR. I have an Azure API for FHIR implemented in my Azure environment. I built and tested several Power BI reports and dashboards against a DIFFERENT FHIR server set up by another team member. It was NOT Azure API for FHIR but rather FHIR on Azure with an App Service. I didn't set this one up. But I did set up the Azure API for FHIR version. After setting my connections in Power BI to this new URL I now cannot read data in my Power BI reports. I can connect, but I get Expression.Error: Access to the resource is forbidden. when trying to read the data. In the Power BI Desktop.

I have made the service multi-tenant.

I have Cleared Permissions as so many of the other posts recommend.

I have tried using a fresh blank Power BI doc.

TerriblyVexed_0-1639413961299.png

 

Any help?


 

Syndicated - Outbound

Hi @TerriblyVexed ,

 

Maybe you haven't added API permissions.

Web App Tutorial - Client Application Setup - Azure API for FHIR | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Syndicated - Outbound

I have

TerriblyVexed_0-1639762184770.png

 

v-chenwuz-msft
Community Support
Community Support

Syndicated - Outbound

Hi @TerriblyVexed ,

 

If it was not Azure API for FHIR, you should  registered an Azure Active Directory resource application for the FHIR server. You must pre-authorize the Power BI client application to be able to access this resource application.

 

vchenwuzmsft_1-1639634380636.png

More detail, please refer this offical article.

FHIR Power Query authentication - Power Query | Microsoft Docs 

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)