Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Can't refresh Semantic Model Connectors: SQL + Sharepoint

Hi all, Preface I have just updated one of my dashboards to use a sql connector instead of a sharepoint connector. This report was refreshing perfectly fine before. In power query I clicked Get D...
  • Anonymous's avatar
    Anonymous
    2 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 Team

     

    If 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!