We have a report which was refreshing fine in Service.
Yesterday in PBI Desktop - we added couple fields to that PBIX' query and visual and it refreshed fine.
But when publishing it to Service and trying to refresh, this is the error!
Its doesnt allow to take over the dataset also. Have anybody seen this before? Thanks! There is no "Query 1" in this PBIX!
You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Query contains unsupported function. Function name: Resource.Access
take a look at this support website of microsoft power bi, there is a message telling about this issue!
Resource.Access still seems to be an internal only function, not supposed to be used by Power BI developers.
Thank you for your reply.
I don't use this function anywhere in my custom connector or PBIx but when published to the service I get this error.
The custom connector works on old data sets published to the service but we get this error when we publish new data sets.
Hi @meenakp ,
Please refer this document.
And compare the provider with the list of supported data sources found in Power BI data sources.
If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that cannot be refreshed in the Power BI service is present.
If it doesn't meet your requirement, we suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @meenakp ,
Can you try by letting the actual dataset owner to provide you the access instead of you trying to take over. Sometimes even this small change works in dataset accesses.
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
Get a sneak peek into this year's Power Platform Conference Keynote.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!