Power bi model, imported Excel from SharePoint

[MasterSonic]

Hi there,

I have a quick question.

Is there a fast way to keep table "offline"?

One of the tables is an Excel file import from SharePoint.

I would like to " disconnect" it from source so it won't refresh, but keep that table as static dataset.

Is there a quick way to do it or I should create new table with data from Excel.

[v-jianboli-msft · Accepted solution]

Hi @MasterSonic ,

Please try:

From SharePoint, open the file in excel

Copy the file path and remove"? web=1" to look like URL below:

Choose your authentication method, for this example I am choosing Organizational account.

Then load the data

For more details, please refer to:

Import data into Power BI Desktop from an Excel sheet in SharePoint - Ruki's Blog (rukiatu.com)

Best Regards,

Jianbo Li

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

[amitchandak]

@MasterSonic , In power query, Right click on table and disable "include in incremental refresh" and try if that can help