Couldn't load data for this visual - direct queries being used

[basketballer202]

Hi Team,

Hope all is well.  I'm running into the following error when publishing out a dashboard into my workspace. 

For context, i have two direct queries from different data sources.  One data source was a PowerBI dataset that I converted into a direct query, the other source was from SQL Server.  

I can view the visuals from the PowerBI desktop application; it only displays the error when i publish it out.  

I do see a 'login failed' but not sure if this is an access-based issue.

Thanks for your help! 

[v-easonf-msft]

Hi, @basketballer202 

Could you please tell me whether your problem has been solved?

If yes, you could accept the helpful answer as solution. You could also share your own solution here.
For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[GilbertQ]

Hi @basketballer202 

If you could have a look at your data source settings for the dataset, I am thinking that they might need to be configured.

This is what it looks like in the Power BI Service

You would need to click on Edit Credentials and put in the required credentials.