Forum Discussion
Can't refresh Semantic Model Connectors: SQL + Sharepoint
- Anonymous2 years ago
Hi Anonymous ,
lbendlin said it well.
When using the Power BI service for automatic refresh, please ensure that the Power BI gateway is installed and correctly configured.
The gateway acts as a bridge between on-premises data and cloud services. It is essential for refreshing data sets that are not directly connected to cloud services.
I tested it with a gateway and found that this was feasible. You can follow the steps below.:
Select the gear icon in the upper right corner.
Click new in the upper left corner to configure data source information.
After the configuration is complete, go to the workspace and select semantic model.
Under the "Gateway and cloud connections" tab, select the gateway you just configured.
For more information, please see:
Manage your data source - import and scheduled refresh - Power BI | Microsoft Learn
If you have any further questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Your SQL Server connection requires a gateway. Open the gateways section and configure it accordingly.
- Anonymous2 years agoNot applicable
Thx for the clarity. Assumed it was this but wasn't sure if a gateway would allow me to connect either because Windows Auth is using the principal user token.