Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
Tips and Tricks
Tutorial Requests
v-xicai's avatar
v-xicai
Community Support
7 years ago

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

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you for your help. v-xicai 

 

So does the salesforce data have to be copy and posted every day manually? Also, just for clarification, is  the salesforce data being appended on one drive?

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi Anonymous ,

     

    It is a clumsy workaround, right?:smileyembarrassed: You may need copy and poste every day manually. For the SalesforceData, you may needn't to upload it to OneDrive for Business.

     

    Best Regards,

    Amy