Forum Discussion
Import data storage
Hello, I am trying to find a way to imported data to an appended data so that when the import refreshes, the appended table keeps growing. For example, there are two data tables, totalDat...
Hi Anonymous ,
There is a workaround you can considerate, following the steps below.
1.Save these data tables in OneDrive for Business, create a new column named "Day number" in totalData table to storage the days in later step 3.
2.Connect to the excel file totalData located in OneDrive for Business using Web connector, see more detail: Use OneDrive for Business links in Power BI Desktop.
3.Once there are new SalesforceData, you can append the new data into the totalData table by doing copy and post.
4.Click Refresh button to get the latest data.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly