I changed Power BI data from excel to SharePoint list

[Sonyat810]

Hi

When I refresh the the data in Power BI, it refreshes the Excel sheet instead of SharePoint list. If I try to delete the Excel sheet, the entire report crashes. How can I change this so that when refreshed in Power BI it only refreshes the SharePoint list.

[v-zhengdxu-msft · Accepted solution]

Hi @Sonyat810 

Here's a link about how to change the power bi data source:

6 Ways to Change Data Source in Power BI - Power Tech Tips

By default, Power BI updates model information from OneDrive and SharePoint on an hourly basis. If you want these updates to occur manually, you can disable automatic OneDrive refresh in the semantic model settings. Open the semantic model settings, expand the OneDrive refresh section, and set the toggle to Off.

Links of how to connect to sharepoint:

Quick steps for connecting to SharePoint using Pow... - Microsoft Fabric Community

How to configure the data source:

Connect to cloud data sources in the Power BI service - Power BI | Microsoft Learn

Best Regards

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

[audreygerred]

When you moved your data to the SharePoint list, did you change your connection string in Power Query so that it is looking at the list instead?