Forum Discussion
Refresh Now and Scheduled Refresh Not Working
We have an Excel spreadsheet with few Pivot Tables reporting data from PowerPivot which data source is an Azure SQL database. The file is saved on a SharePoint Online library. This report was working...
I tried with several excel spreadsheets with pivot table in it, I always has “SqlServer” in Data source credentials.
We should only have Azure SQL server name while we connect to Azure DB directly.
Best Regards,
Herbert