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.
Hi All,
I am trying to setup a dataset scheduled refresh, but Power BI Service is refusing to accept that I have a data connection...
I have setup the Gateway datasource and it states 'Connection Successful'
I've then created a report in Desktop using on that datasource:
I've then published to Service, and tried to schedule a refresh for the dataset for that report, and i get the message saying:
I'm now completely at a loss as to why this isn't working.
If anyone has any advice on what else i can check I'd really appreciate it.
Many thanks,
Nick
Solved! Go to Solution.
@Nickodemus,
Based on your screenshots, you are using different server names in gateway and Power BI Desktop.
In Power BI Desktop, you use "." to connect to local SQL Server instance, please change it to the same server name as that you use in gateway connection string, then re-publish PBIX file, this way, you will be able to set schedule refresh for your dataset.
Regards,
Lydia
@Nickodemus,
Based on your screenshots, you are using different server names in gateway and Power BI Desktop.
In Power BI Desktop, you use "." to connect to local SQL Server instance, please change it to the same server name as that you use in gateway connection string, then re-publish PBIX file, this way, you will be able to set schedule refresh for your dataset.
Regards,
Lydia
Ahh!! Genius! Thank you. That worked a treat, and now it looks so obvious; I was using local server address, rather than the full address.
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.