Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
When publishing a pbix file using composite models connected to Azure SQL DB + incremental refresh, the following error is encountered in the service when viewing the dataset settings:
You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Data source for '{"protocol":"ado-dot-net","address":{"options":{"data source":"myazuresqlserver.database.windows.net","initial catalog":"myazuresqldb","encrypt":"True","trustservercertificate":"False"},"provider":"System.Data.SqlClient"},"authentication":null,"query":null}'
Connectivity in the published PBIX was created using get data -> Azure SQL DB, depicted by the following M snippet below:
Source = Sql.Database("myazuresqlserver.database.windows.net", "myazuresqldb")
Steps to reproduce:
Only the combination of composite model + incremental refresh results in an error. As per documentation for incremental refresh, composite models should be supported: https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#limitations
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.