Forum Discussion

jatneerjat's avatar
jatneerjat
Helper V
7 years ago
Solved

DataSet error on power BI service

Hi,

 

I am getting below error for all my datasets.Data source is cube and i am using Direct Query.

The error is for schedule refresh.

 

 

 

How can i resolve this error?

 

Thanks

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi jatneerjat,

     

    I'd like to suggest you check datasets and gateway data source settings if they are anything wrong with them.

    BTW, I can't find anything useful from your snapshot, it only told us something wrong with your dataset, but nothing detail mentioned.(this is a common error message)


    Regards,

    Xiaoxin Sheng

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI jatneerjat,

     

    Can you please share more details about your dataset settings? 

    In addition, it seems like a known issue power bi team already list on support page, please take a look on it if your scenario is suitable for its description:

     

    Instead of receiving a message to enter credentials, customers using a Direct Query Model that connects to a SQL Azure data source will receive a pop-up "Couldn't load the schema for the database model" error message when opening the report if their SQL Azure credentials are incorrect. To fix the credentials, please go to dataset settings page and enter the correct credentials. Engineers are working on a fix and expect it to be deployed to all regions by end-of-day 11/30/18. 

     

     

    Regards,

    Xiaoxin Sheng

    • jatneerjat's avatar
      jatneerjat
      Helper V

      Hi Anonymous 

       

      The below scenario mentioned by you is not related to my issue as i dont have azure sql db but an on premise SSAS cube.

      My data source is not able to refresh by itself and it shows the error as mentioned by me.

       

      Thanks,

      Neeraj

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi jatneerjat,

         

        I'd like to suggest you check datasets and gateway data source settings if they are anything wrong with them.

        BTW, I can't find anything useful from your snapshot, it only told us something wrong with your dataset, but nothing detail mentioned.(this is a common error message)


        Regards,

        Xiaoxin Sheng