Forum Discussion

Harris021's avatar
Harris021
Frequent Visitor
1 year ago
Solved

How to sync PowerBI data source

Hi all,

 

I'm new to the world of Power BI and I'm hoping to benefit from the expertise of this community. I've connected a SharePoint online list to Power BI as a data source and I'm creating a basic report.

Every morning, I go to Power BI, click on the refresh button, and republish to get the latest data. Is there any way I can make this happen automatically?

 

Harris,

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Harris021 ,

    Please follow the screenshot below to update your credentials.


    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Harris021 ,

    Create a report in Power BI Desktop from a data source connected to a SharePoint online list and then publish it to Power BI Service.
    In this case, you can access the settings for this report semantic model in Power BI Service.

     

    You can then set up a scheduled refresh for that semantic model to enable a daily refresh of the semantic model for the latest data.


    Please refer to the following link to learn more about the scheduled refresh.

    Configure scheduled refresh - Power BI | Microsoft Learn

     

    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Harris021's avatar
      Harris021
      Frequent Visitor

      Thanks for the message, do you know why my refresh section is grayed out.

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Harris021 ,

        Please follow the screenshot below to update your credentials.


        Best Regards,
        Dengliang Li

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.