Forum Discussion
Relation between OneDrive Excel sheet with online PowerBI
Hi Anonymous ,
Based on the information you provided. One thing to note for onedrive refresh:
- Unlike a semantic model refresh during which Power BI imports data from a data source into a semantic model, OneDrive refresh synchronizes semantic models and reports with their source files. By default, Power BI checks about every hour if a semantic model connected to a file on OneDrive or SharePoint Online requires synchronization.
- Power BI performs refresh based on an item ID in OneDrive, so be thoughtful when considering updates versus replacement. When you set a OneDrive file as the data source, Power BI references the item ID of the file when it performs the refresh. Consider the following scenario: you have a master file A and a production copy of that file B, and you configure OneDrive refresh for file B. If you then copy file A over file B, the copy operation deletes the old file B and creates a new file B with a different item ID, which breaks OneDrive refresh. To avoid that situation, you can instead upload and replace file B, which keeps its same item ID.
Fore more detail, you can refer to below document:
Refresh a semantic model from OneDrive or SharePoint Online - Power BI | Microsoft Learn
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
Based on the information you provided. One thing to note for onedrive refresh:
- Unlike a semantic model refresh during which Power BI imports data from a data source into a semantic model, OneDrive refresh synchronizes semantic models and reports with their source files. By default, Power BI checks about every hour if a semantic model connected to a file on OneDrive or SharePoint Online requires synchronization.
- Power BI performs refresh based on an item ID in OneDrive, so be thoughtful when considering updates versus replacement. When you set a OneDrive file as the data source, Power BI references the item ID of the file when it performs the refresh. Consider the following scenario: you have a master file A and a production copy of that file B, and you configure OneDrive refresh for file B. If you then copy file A over file B, the copy operation deletes the old file B and creates a new file B with a different item ID, which breaks OneDrive refresh. To avoid that situation, you can instead upload and replace file B, which keeps its same item ID.
Fore more detail, you can refer to below document:
Refresh a semantic model from OneDrive or SharePoint Online - Power BI | Microsoft Learn
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hey Kong,
Thank u for ur help. I had no idea about those facts and will cooperate with PowerBi from now on, to be as useful and effecient as it can.
I will try to upload and replace the file you suggested to see if it will work after it. However, I´ve just discovered that I dont´t have a gateway for my data. Therefore, the PowerBi service app it´s not fully working. If I could have a guess, I´d say this is one of the main cause for errors as well.