Corey Kropp on 29 Nov 2017 03:09:56
Enterprise/Personal Gateways Schedule Refresh
I would like to schedule auto refreshes for import connections via an enterprise gateway to SQL Server Analysis Services.
In my pbix file, I am connected to a SQL Server Analysis Service (import mode) via an enterprise gateway and an Azure SQL databases via a personal gateway. I would like to schedule auto refreshes for all data source within PowerBI Service. I cannot schedule auto refreshes due to PowerBI limitations. If i create a live connection to the SQL Server Analysis Services, I can schedule auto refreshes, but cannot overlay data from the Azure SQL Database.