Forum Discussion

bumoverflow's avatar
bumoverflow
Frequent Visitor
1 year ago
Solved

Cosmos DB ResourceAccessForbiddenException

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 m...
Need Help
  • bumoverflow's avatar
    bumoverflow
    1 year ago

    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's avatar
v-pnaroju-msft
Community Support
1 year ago

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.