Forum Discussion
Cosmos DB ResourceAccessForbiddenException
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
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.