Query contains unsupported function. Function name: Resource.Access

[rocky09]

Hi Community,

I have a report with multiple queries and it has been working fine since yesterday. But, suddenly throwing this error "Query contains unsupported function. Function name: Resource.Access"

I have checked the data sources and everything looks good, and the tables/queries are refreshing without any errors in the Desktop version. However, the problem with the Power BI Service. The Data source credentials and Scheduled Refresh options are not available and the report is getting failed.

Additional Information:

Sources included in the report:  Oracle, SQL, and Python

[Syndicate_Admin]

I have the same problem everything worked well and from one moment to another I send myself

and then on the web I put this

What needs to be done to fix it since it does not even give you the opportunity to place a gateway in case that was the reason.

Hopefully they can help themselves.

Thanks and regards.

[v-rongtiep-msft · Accepted solution]

Hi @rocky09 ,

take a look at this support website of microsoft power bi, there is a message telling about this issue!

Support | Microsoft Power BI

Engineers are investigating the issue and an update will be provided soon.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[djurecicK2]

Hi @rocky09 ,

 Here is the only thing I could find on that error:

https://community.powerbi.com/t5/Service/Refresh-error-Query-contains-unsupported-function-Function-...

[rocky09]

Thank you for your reply. I have already referred the link you have shared and my issue is not resolved.