Forum Discussion
Dynamics 365 Expression.Error: Access to the resource is forbidden.
Hi salih7,
Thanks for using Microsoft Fabric Community Forum.To resolve the "Expression.Error: Access to the resource is forbidden" error you're encountering in your query, we recommend the following approach:
First, we can verify if each table is accessible before attempting to expand its data. This can be achieved using the try...otherwise construct in M language, which checks the accessibility of the Data column for each table. If the expansion of the Data column is successful, the table will be marked as Accessible. If the operation fails it will be marked as Not Accessible.
We will then add a new column, AccessStatus, to indicate whether each table is accessible or not. Afterward, we can filter out the tables marked as "Not Accessible" and expand the "Data" column only for the accessible tables. This process ensures that only the tables which can be expanded will be included in the result, thus avoiding the access error and allowing smooth data retrieval.
If you need further assistance or have any questions, feel free to reach out.
Please Accept as solution if this meets your needs and a Kudos would be appreciated.Thank you.
Community SupportHi salih7,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Community SupportHi salih7,
Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help.
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.