The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
I am using the import method to bring in data from azure SQL database. When I publish the report to a workspace, I cannot schedule a refresh (it is greyed out) and when I try to refresh on demand in the workspace I get an error (see below).
I checked on these forums and most people just deleted their dataset and tried again and it worked but I have tried deleting and re-publishing multiple times and it's not working still. Any ideas on how to get this to work?
Hi @Anonymous ,
If your dataset not only contains Azure SQL Database but also the on premise data source, then it needs to use the gateway and configure schedule refresh, recommend you use enterprise gateway instead of personal gateway, see more: :On-premises data gateway , Configure scheduled refresh ,Manage your data source - SQL Server .
Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
Or try to upgrade the gateway to latest version.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-xicai Hey Amy - thanks for the reply but like I stated in my previous post - I'm only using data from the Azure SQL DB. Any ideas why this is happening then? I don't believe I need a dateway for this