Forum Discussion

GoingIncognito's avatar
GoingIncognito
Icon for Advocate III rankAdvocate III
6 years ago
Solved

Using SSMS to refresh PBI tabular model in portal

Hi!

Any ideas what I'm doing wrong here?

I have a workspace in premium capasity. I used SSMS to connect to tabular model. When I try to process either any database or table within a database I get this error message. My desktop version is July 2020 and preview feature for enhanced dataset metadata, which is as I understand the V3 mentioned in error message below.

 

 

 

Could the problem be following: I have earlier created the report. Now I returned to switch on the new preview feature. So the query in guestion is now updated? Should I first enable the preview and then create a query from scratch?

 

Need Help

4 Replies

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi GoingIncognito ,

     

    Glad you found the solution.

     

    To be additional, Power BI returns the following error if you perform a refresh via the XMLA endpoint against a model without enhanced metadata.

    For details, you can refer to the following document.

    https://docs.microsoft.com/en-us/power-bi/admin/troubleshoot-xmla-endpoint

     

    Best regards,

     

    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.

    • GoingIncognito's avatar
      GoingIncognito
      Icon for Advocate III rankAdvocate III
      6 years ago

      v-zhenbw-msft 

      Thank you. One, hopefully last question:

       

      When default compatibility level is, but at the same time a singular database level within it is as low as 1465

      What should be updated? SSDT? PBI desktop? I thought July edition supported enhanced metadata format?

       

       

      And enhanced metadata format is set ON as preview feature: