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.
We have noticed that power bi service fails data refresh (manual or scheduled) when the data source is SQL Server 2008 R2. The refresh is successful for SQL Server 2012. The data source connection is successful in the gateway, how ever the manual or scheduled refresh fails with message "Unable to connect to the data source undefined."
We have multiple reports running successfuly when the data source is SQL Sever 2012; however the data sets that have data in SQL Server 2008 R2 seem to be having this issue. Is this a known limiation?
Please refer the below link. If the issue persists, please submit a support ticket.
If this post helps, then please consider Accept it as the solution to help the other members find it more
The resolution did not help in this case.
Also, we are using Import (not direct query), just to make sure that box as well has been checked
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.