Forum Discussion
Helper IVPower bi model, imported Excel from SharePoint
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.
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.
2 Replies
- amitchandak
Super User
MasterSonic , In power query, Right click on table and disable "include in incremental refresh" and try if that can help
v-jianboli-msftCommunity Support
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.
