How to sync PowerBI data source

[Harris021]

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,

[Harris021]

Thanks, that was great.

[Anonymous]

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]

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

[Anonymous · Accepted solution]

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.