Forum Discussion

Kletzy's avatar
Kletzy
Icon for Advocate III rankAdvocate III
3 years ago
Solved

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 Gatew...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

     

     

leoc's avatar
leoc
Icon for Advocate I rankAdvocate I
3 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I just had a call with Microsoft. The product group is aware of the issue and are working on a fix.
    Will let you guys know once I get an update.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thanks for the info. Awaiting the solution!!

    • flavia's avatar
      flavia
      Icon for Advocate II rankAdvocate II
      3 years ago

      thanks! I'm waiting for it 🙂

  • KostasDiam's avatar
    KostasDiam
    Regular Visitor
    3 years ago

    Same problem here too. Pbix refresh works fine, but service refresh dosen't.

    I am using MariaDB connector and it shows me this:

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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."

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      AWESOME! Thanks for the news. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi all! Please promote this issue. It is without a doubt some change in the Power BI/Power BI Gateway (Personal Mode) service. Some Azure clusters stop working before others, mine located in WABI-SOUTH-CENTRAL-US, stopped in '2022-11-25T15:42:07.0000000Z'. If someone has already opened a case with Microsoft, please share the link.

    Hang in there!