DataSet error on power BI service

[jatneerjat]

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

[v-shex-msft]

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]

Hi @v-shex-msft 

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

[v-shex-msft · Accepted solution]

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