Forum Discussion
Query contains unsupported function. Function name: Resource.Access
My data refreshes have been working smoothly but have been giving various issues since the weekend. The desktop refresh works fine. I also suddenly can't see options for credentials or for the Gateway that is in place. I have been having service issues since Saturday morning when first the custom connectors failed for 24 hours, then started working again, this morning the Gateway wasn't being seen by the service then briefly came back and now I can't do any refreshes at all. I suspect its something to do with the Nov release?
I receive the following message:
You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
- Data source for Query1
Query contains unsupported function. Function name: Resource.Access
Hi all,
Get the latest feedback:
This issue has been deployed and validated.
PROD - 11.4 QFE –12/10 and 12/11 - Sat with US clusters- Sunday.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
78 Replies
Hi all,
Get the latest feedback:
This issue has been deployed and validated.
PROD - 11.4 QFE –12/10 and 12/11 - Sat with US clusters- Sunday.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Personally, I think Microsoft really dropped the ball on this one - it took 5 days from when I initially posted the issue for it to be acknowledged on the support page - this has been a major problem for many of us.
Absolutely agree. This was worryingly underrated. The PBI service and the gateways should be considered as one. I don't know what kind of company has established a direct communication between their production data servers and the Power BI service, in my case and probably in many entities that value the security of their clients, that will never happen. Therefore, the only way we have to implement the Power BI service is through the gateways, it's just this, without gateways there is no service. So what do they mean when they report that everything is running smoothly, except for an irrelevant issue with the gateways? And the week to solve it...
So no correction until this week-end on PROD ? So one week with this errors 🤔
I got other information from Microsoft. What is now correct!?
PG has recently confirmed that the fix will be deployed during train 12.2 or 12.4 (12.3 was cancelled) roughly they said it will be deployed between end of December or early January. Unfortunately, there is no workaround provided so far.
We will keep you posted if there will be anything Product group would share for partial mitigation or workaround to be used before the fix will be deployed.I don't think that this issue is being taken with the severity level it really has. How many of us/our companies are paying for this service and depending on this connectors to feed all our information systems. How can they inform that the "Service Status Per Region" is "Good"? Isn't it the Gateway part of the "Service"?
Similar issue from my side! But I know it comes from my Python script...
Even if the refresh is working on Desktop but not when I want to do it on Power Bi online.latest update from Microsoft:
Product group just mentioned the fix is prepared and is being checked and validated to ensure it will work as intended. After that it might take few days to be deployed to all clusters. It is most concrete information we have currently so I believe it will not take too much time but still I cannot give you exact ETA for deployment as PG did not give us any.
Same problem here too. Pbix refresh works fine, but service refresh dosen't.
I am using MariaDB connector and it shows me this:
https://powerbi.microsoft.com/en-us/support/
they say "Power BI customers trying to configure credentials for datasets using Gateway may see the following error message "Query contains unsupported function. Function name: Resource.Access". Engineers have identified the root cause and a fix is expected to be deployed by end-of-day 12/11/2022."
Same with Athena connector...
Same issue with Denodo connector...
this message is on the support website of microsoft power bi https://powerbi.microsoft.com/pt-br/support/
hugs from brazil to everyone 😉On the main support page as well: Support | Microsoft Power BI
Same issue here, also working with custom connector from Davista, Google Sheets and Odata feed.
Problem started this weekend before everything worked fine, even removed on a backup all my changes from last week to an earlier version and that one now gives the same errorI'm also having the same issue while my Database is hosted on MariDB. gateway for maria db working fine. Data Refresh on PBI Desktop is fine but creates problem on Services.
I have also raised a ticket, as I am experiencing the same issue.
We have the same issue. Did anyone solve it?
