Cosmos DB ResourceAccessForbiddenException

[bumoverflow]

Hey everyone,

I have a table that queries Cosmos DB with custom SQL. When I refresh the view in Power Query everything's fine. But when I want to refresh entire datamodel, i've got following error message:

Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException

What could be causing this issue?

[v-pnaroju-msft]

Hi bumoverflow,

We are pleased to hear that your issue has been resolved. Kindly mark the response that resolved your issue as the accepted solution. This will help other community members facing similar challenges to find solutions more efficiently.

Please continue using Fabric Community for any help regarding your queries.

Thank you.

[bumoverflow · Accepted solution]

Thank you for the response. The issue was caused by a User-Defined Function (UDF) in CosmosDB. While it executed correctly in the Data Explorer in Azure, it caused significant problems when used in Power Query. We removed this function, and now all data loads successfully.

The problem is resolved, but unfortunately, we do not know why the UDF caused this issue with the CosmosDB connector. Perhaps UDFs are buggy, which might explain why they are not available in version 2 of the CosmosDB connector

[v-pnaroju-msft]

Hi @bumoverflow,

We sincerely appreciate your inquiry through the Microsoft Fabric Community Forum.

Kindly follow the troubleshooting steps provided below to resolve the issue:

• Ensure that the account accessing Cosmos DB has the necessary read permissions for the database and container.
• Verify the connection settings in Power BI by navigating to File > Options and Settings > Data Source Settings, and ensure that the correct credentials are being used.
• Re-enter the credentials, as doing so can often resolve underlying issues related to credential caching.
• Confirm that the Power BI service IPs are whitelisted in the Azure Cosmos DB firewall.
• Create a basic query in Power Query to verify if it refreshes successfully. This step will help in isolating the issue.

If you find the response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will greatly assist other community members facing similar issues.

Thank you.