in viewing unable to connect to the datasource

[Anonymous]

Hello,

https://community.powerbi.com/t5/Issues/unable-to-connect-to-the-datasource/idi-p/1954204

My reports that pull data from SQL no longer work. All sql linked reports have this problem. There is no problem only in excel data source reports.

Data Source Settings appear to be working correctly.

Privacy level looking correct.

Refers history lokking good.

Power BI desktop lookimg good.

But my reports are not opening as below, since the weekend.

[Anonymous]

Hello,

My reports that pull data from SQL no longer work. All sql linked reports have this problem. There is no problem only in excel data source reports.

Data Source Settings appear to be working correctly.

Privacy level looking correct.

Refers history lokking good.

Power BI desktop lookimg good.

But my reports are not opening as below, since the weekend.

[Anonymous · Accepted solution]

solved after sql server restart.

[Anonymous]

Hi @v-yingjl 
We have been using power bi reports in our company for 2 years and we do not have any problems.
In the message you shared, he wrote solved the problem with incoming instructions coming from Microsoft.
How will I solve it? Our reporting part is broken in our company, can you please give me real and quickly help?

[v-yingjl]

Hi @Anonymous ,

Have you set the same gateway for each combined data source? 

Or you can try this simliar workaround:

Set the server certificate to blank, then back to the original value; saved the settings, then restarted the SQL Server windows service.

Here is the simliar issue: https://community.powerbi.com/t5/Service/Unable-to-connect-to-the-data-source-undefined/m-p/753020 

Best Regards,
Community Support Team _ Yingjie Li

[arvindsingh802]

Please upgrade the Power BI Gateway to latest version

if that does not resolve, please raise support ticket with Support | Microsoft Power BI

If this post helps, then please consider Accept it as the solution and give it a thumbs up

[Anonymous]

Hello @arvindsingh802 

I'm already using latest version.

I createad ticket.

https://community.powerbi.com/t5/Issues/unable-to-connect-to-the-datasource/idi-p/1954204