Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

0

Query contains unsupported function. Function name: Resource.Access

Submitted by Anonymous on ‎09-18-2024 04:02 AM

I started getting this message suddenly for my dataset, and the "Gateway and cloud connections" is not showing. The dataset is using a custom connector (self signed) via a gateway.


I stripped the queries down, and got this dataset to work.

 

However, when I then tried adding different queries it failed again. Now I have stripped down again, and I am left with the same query as for the dataset/semantic model that works.

 

I can not find any difference between the working and not working dataset.

How can I figure out what the cause of this error is? All of the versions work perfectly in PowerBI Desktop. Also, I have tried reauthenticating within desktop, before publishing again. 

Highly appreciate any tips and/or help. (PS, I found a very similar thread from 2022, this was a bug that was fixed.

Status: Delivered
See more ideas labeled with:
6 Comments (6 New)
Comments
LucasPBI
New Member
‎09-18-2024 10:11 AM

same here with snowflake

 

Anonymous
Not applicable
‎09-19-2024 12:12 AM

Hi @Anonymous 

What connector are you using ? Have you made any changes in the meantime? Also did your Desktop do an automatic update?

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎09-19-2024 12:49 AM

We're a Saas-solution delivering our own connector. No updates made.

In another channel to Microsoft, I got the message that it was a known issue, and that they were working on a fix that so far had no ETA. I tried to get a link to the issue itself, but did not exist either. Weird way of handling it...

Anonymous
Not applicable
‎09-19-2024 01:01 AM

Not sure how automatic update works in Desktop, but I did update/refresh the data and it all works fine. No errors at all in Desktop.

Anonymous
Not applicable
‎09-20-2024 01:44 AM

Hi @Anonymous 

Yesterday a lot of users reported a little problem with Desktop, but the problems that arose were not the same. However, after the PG team updated the program for the Store App, everything is back to normal. Apparently, your problem could also be caused by a program update. Anyway, glad you can use your Desktop normally now.

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎09-30-2024 01:01 AM

There was different datasets that acted differently, and the error message was not that informing.

However, the problem was due to no connections being available in the setup. Having one valid connection solved the issue.

Idea Statuses