Expression.Error: Access to the resource is forbidden.

[Mekist]

Hello

https://api.fintables.com/analyst-ratings/?brokerage_id=&code=&in_model_portfolio=

When accessing the address above over the internet, Power BI gives an error saying "Access to the source is prohibited."

Is there a way to bypass the error?

[v-lgarikapat · Accepted solution]

Hi @Mekist ,

Thanks for your prompt response

API calls are now working as expected, as shown in the screenshots. I am able to fetch the data into Power BI, and it is also working on the web

Power BI may be blocked from accessing an API even if it works in a browser due to several reasons. Web servers can return a 403 Forbidden error when they detect requests from non-browser tools like Power BI, often based on missing headers such as User-Agent, Referrer, or Origin. Power BI typically sends minimal headers, which can cause the API to reject the request. Additionally, corporate networks may impose firewall or proxy restrictions that prevent Power BI from reaching certain URLs. Power BI's own privacy settings can also isolate or block web calls if data privacy levels are too strict. Lastly, previously cached or saved credentials may interfere with new API calls unless they are manually cleared.

@Mekist  Please follow the troubleshooting steps outlined below and let us know the outcome at your convenience

To troubleshoot access to the Fintables API in Power BI, first confirm the API is public (which it is, since it loads in your browser). In Power BI, go to File > Options and settings > Data source settings, clear permissions for https://api.fintables.com, and restart Power BI. Next, use Web.Contents in Power Query with a spoofed browser User-Agent header to bypass simple blocks. If you still get Access to the resource is forbidden, go to File > Options > Privacy and set it to Ignore privacy levels. If access is still blocked, try a different network (e.g., home or mobile hotspot) to rule out corporate firewalls. As a reliable workaround, use Python in Power BI: install Python and required packages using pip install panda’s requests, then enable Python scripting in Power BI’s options. When using the Python connector, if you get ModuleNotFoundError, it means you need to install missing packages (like pandas). Finally, if Python is not an option, consider setting up a free API proxy (with Pipedream or Apify) to forward the API request and access the proxy URL in Power BI instead.

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out we’d be more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi

[v-lgarikapat]

Hi @Mekist ,

Thanks for reaching out to the Microsoft fabric community forum.,

@danextian ,

@kushanNa ,

@rajendraongole1  

Thank you for your prompt response and valuable input

In addition to the above troubleshooting steps, I have included the previously resolved threads and learning documents, which may be helpful in resolving the issue.

Solved: Access to the resource is forbidden error while ac... - Microsoft Fabric Community

Troubleshoot Power BI REST APIs - Power BI | Microsoft Learn

Solved: 403 forbidden error while trying to call power bi ... - Microsoft Fabric Community

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out  we’d be more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi

[Mekist]

Hello @v-lgarikapat 

Thank you for your feedback.

I noticed that the solutions you shared didn't provide clear solutions.

I couldn't understand why Power BI access is not available when there's access from the web.

[v-lgarikapat · Accepted solution]

Hi @Mekist ,

Thanks for your prompt response

API calls are now working as expected, as shown in the screenshots. I am able to fetch the data into Power BI, and it is also working on the web

Power BI may be blocked from accessing an API even if it works in a browser due to several reasons. Web servers can return a 403 Forbidden error when they detect requests from non-browser tools like Power BI, often based on missing headers such as User-Agent, Referrer, or Origin. Power BI typically sends minimal headers, which can cause the API to reject the request. Additionally, corporate networks may impose firewall or proxy restrictions that prevent Power BI from reaching certain URLs. Power BI's own privacy settings can also isolate or block web calls if data privacy levels are too strict. Lastly, previously cached or saved credentials may interfere with new API calls unless they are manually cleared.

@Mekist  Please follow the troubleshooting steps outlined below and let us know the outcome at your convenience

To troubleshoot access to the Fintables API in Power BI, first confirm the API is public (which it is, since it loads in your browser). In Power BI, go to File > Options and settings > Data source settings, clear permissions for https://api.fintables.com, and restart Power BI. Next, use Web.Contents in Power Query with a spoofed browser User-Agent header to bypass simple blocks. If you still get Access to the resource is forbidden, go to File > Options > Privacy and set it to Ignore privacy levels. If access is still blocked, try a different network (e.g., home or mobile hotspot) to rule out corporate firewalls. As a reliable workaround, use Python in Power BI: install Python and required packages using pip install panda’s requests, then enable Python scripting in Power BI’s options. When using the Python connector, if you get ModuleNotFoundError, it means you need to install missing packages (like pandas). Finally, if Python is not an option, consider setting up a free API proxy (with Pipedream or Apify) to forward the API request and access the proxy URL in Power BI instead.

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out we’d be more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi

[v-lgarikapat]

Hi @Mekist ,

I wanted to follow up and confirm whether you’ve had the opportunity to review the information we provided. Should you have any questions or require further clarification, please don't hesitate to reach out.

If you are still encountering any challenges, we would be happy to assist you further.

Best Regards,

Lakshmi

[Mekist · Accepted solution]

Hello.
I've been sick for a few days and haven't been able to reply. Please excuse me.

I tried the options and retrieved the data without the API. I'm not sure if there was a fix on the source side or if the actions were taken.

Thank you for all your support.

[danextian]

Possibly because you're not using an API token.

[Mekist]

@danextian 

Yes, I don't use it. I think it shouldn't ask for it here when accessing from the web.

[kushanNa]

Hi @Mekist 

I believe some websites allow API content to be visible in the browser but block access when using tools. Check this link as an example: https://www.sofascore.com/api/v1/event/13801245/statistics. I believe you'll need to contact their support team and request access to the data.

[Mekist]

Thank you @kushanNa 

[rajendraongole1]

Hi @Mekist - You tried accessing the API URL directly in a web browser or Postman? If so, does it return data successfully?

Could you share the exact error message shown in Power BI, including any technical details or diagnostics?

Share more details about the above activity it helps to understand the issue.

[Mekist]

@rajendraongole1  Hi

Yes, I can access it via the browser, the data is returning successfully.

When I add the link in Power BI, it gives the following error: