Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
solved after sql server restart.
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?
Hi @koray ,
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.