Forum Discussion
Scheduled Refresh
Hi cmelgar,
Thanks for your update.
Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your issue or provide a solution that isn't immediately obvious.
Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft LearnIf this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Hello cmelgar,
Thank you for reaching out to the Microsoft Fabric Community forum.
After thoroughly reviewing the details you provided, here are some steps you can take to resolve this issue:
- Check that the connection string used in Power BI Desktop matches the one configured in the gateway. The server name should be in the format "Servername,portnumber".
- Make sure that the on-premises data gateway is properly set up and configured. The gateway acts as a bridge between the Power BI service and the on-premises data source.
- Review the gateway logs for any specific error messages or clues that might indicate what is causing the connection issue.
For your reference:
Solved: Cannot schedule refresh dataset from SQL Server be... - Microsoft Fabric Community
Solved: Refreshing data from SQL Server - Microsoft Fabric Community
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.