Question

You publish a semantic model to the Power BI service. The model uses Import mode and connects to a Microsoft SQL Server database hosted on a physical server in your company's on-premises data center. You configure scheduled refresh, but the refresh fails immediately with an error indicating the data source cannot be reached. What must you do to enable successful scheduled refresh?

Accepted Answer

Install and configure an on-premises data gateway (standard mode) and map the SQL Server data source to it in the gateway settings

Answer

Switch the semantic model from Import mode to DirectQuery so the service queries the database live

Answer

Increase the scheduled refresh frequency to the maximum of eight times per day on Pro capacity

Answer

Grant the semantic model's owner the Contributor role in the workspace