Forum Discussion

deepu299's avatar
deepu299
Icon for Advocate V rankAdvocate V
6 years ago

XMLA Endpoint in Power BI Service

Hi, 

 

I don't know if this is possible but couldn't find exact answer : 

1. I have a pbix file "MasterDataset", pulling data from SQL DW

2. Published the dataset to a workspace under power bi premium

3. Created another pbix "analytics", with datasource from #2 using XMLA Endpoint. connection is using Analysis Services.

4. Published the pbix "analytics" to same workspace. Will this work? I am getting an error "Couldn't load the model schema associated with this report."

 

Thanks. Appreciate your help with this.

General Comment
Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago
    Seems like that should work but perhaps try a Power BI Live connection?
    • deepu299's avatar
      deepu299
      Icon for Advocate V rankAdvocate V
      6 years ago

      Greg_Deckler  Thanks Greg. It is a live connection and it is working fine when not published in the service. Once published to the service, it is not understanding the database. 

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

        Hi   deepu299 ,

         

        Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

         

        Best regards

        Amy

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

    Hi deepu299 ,

     

    If your dataset of  the pbix "analytics" contains on premise data source, then it needs to use the gateway , and you can use demand refresh or configure schedule refresh to get updated data, see more: :On-premises data gateway , Configure scheduled refresh . 

     

    In addition, you need to set Map user name in Manage gateway for the SSAS datasource, replace your Power BI account with the your local gateway installed computer domain_name\user_name. For reference: Map user names for Analysis Services data sources.

     

    You may resolve the issue via the troubleshooting link: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#data-sources .

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.