Forum Discussion
Semantic Model connected to Lakehouse SQL Analytics endpoint not refreshing
Yeah, after a second test, this appears to be working...
So, all I've done is add a Script activity which runs a simple SELECT TOP 1 * FROM ... against one of the views in my Lakehouse SQL Endpoint, then a Wait activity that waits for 60 seconds, before the Semantic Model Refresh activity. I'm not sure if the Wait is actually necessary, but I figure it can't do any harm...
Hello DuncanKing,
It sounds like the issue might be related to the data source credentials or the workspace configuration.
Here’s what I would suggest checking:
Verify Data Source Credentials
Go to the Dataset settings in the Power BI Service for your semantic model.
Check that the Lakehouse SQL Analytics endpoint credentials are correctly configured (authentication method and permissions).
If credentials are missing or invalid, scheduled refresh can appear as “successful” but won’t actually pull new data.
Scheduled Refresh Settings
Ensure that a scheduled refresh is properly configured in the semantic model settings (not just the pipeline activity).
Confirm that the refresh history shows actual row changes after each run.
3. Workspace Capacity
If your semantic model is in a Pro workspace but the Lakehouse is in a Fabric capacity, consider moving the semantic model into the same Fabric workspace or capacity.
This ensures optimal connectivity and avoids possible cache or credential mismatches.
4. Manual Refresh Works
Since a manual refresh works, this almost always points to either credential misconfiguration or refresh settings not being applied correctly.
Hope it can help you !
Best regards,
Antoine