Forum Discussion

arathore's avatar
arathore
Frequent Visitor
8 years ago

Couldn't load the schema for the database model

Hi, I got my Power BI gateway setup and got a live connection to SSAS tabular model. I can see the gateway is running and data is getting refreshed hourly. I created my first report in PBI desktop ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi arathore,

 

Could you go to check the Dataset Settings, and the Data Source Settings under Manage Gateways for the issue dataset to see if there are any errors and post the errors here? (Do mask sensitive data before sharing) :smileyhappy:

 

 

Regards

  • arathore's avatar
    arathore
    Frequent Visitor
    8 years ago

    it seems like my gateway is connected to the data source and is running fine as refresh is successful.

    When I am publishing the report, I see this error. Why the data source is unable to connect the gateway

     

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi arathore,

       

      It's so weird to me. :smileymad: The schedule refresh is successful, however, both the error messages just indicate that you haven't add your data source to your gateway.

       

      Are these screenshots posted above for the same report/dataset? If there is any possibility that you're using a different data source(or added some new data sources i.e. an Excel file which also need be added to the gateway) in the new published report? :smileyhappy:

       

      Regards

      • arathore's avatar
        arathore
        Frequent Visitor
        8 years ago

        Hi v-ljerr-msft

        I am using SSAS tabular model and not excel sheet data. I was wondering if this is a gateway compatibilty issue. My Power Bi desktop was last installed in Jul 2017, while my gateway was installed in Sep 2017. Can updating the desktop version solve the issue ?