Forum Discussion

Minaaa_Z's avatar
Minaaa_Z
Regular Visitor
1 year ago
Solved

Replace onedrive new datafile or not when refreshing

Hi,

 

I am confused about refreshing by onedrive in power bi.

 

Now i have created a report by using several dataset files though Get data > Web > [dataset path copied by file detail] and uploaded like this seperately. I need to update and refresh daily. So i have also set the incremental refresh. 

 

My question is:

1. Since I uploaded the data by onedrive link, in the furture how can I upload and refresh the new data? Do I just delete the old one and upload the new one in the same folder (keep the file name same and all the format same inside the file)?

 

2. Since I uploaded the data by each files, it looks like it would be better if i connect with the onedrive folder not the exact file? If so I ahve tried to change the path of the dataset from file to folder, but when I wanna connect with my microsoft account it failed:  ''We couldn't authenticate with the credentials provided. Please try again - Using right credentials'' 

 

3. If I connect the data by files, will it be better and more efficient for future refresh? If in this way, is it like I donot need to delete any old files and donot need to keep the same name, just add new files in the same folder and it will recognize automatically?

 

Thanks a lot for helping me. Much appreciated.

  • Instead of using the link for a file, use the link to the root folder, then it will consider all the newly added files also.

1 Reply

  • Instead of using the link for a file, use the link to the root folder, then it will consider all the newly added files also.