Forum Discussion

robgar's avatar
robgar
New Member
9 years ago
Solved

Dataset Refresh and Pubishing Questions

I'm new to PBI.  I am a remote user not on any corp network.   I have built in PDI Desktop a report that uses a XLS located in my O365 Sharepoint Document library.  I use a http address for my data s...
dimazaid's avatar
dimazaid
Microsoft Employee
9 years ago

Hello again,
Why are you updating the data immediatley in PBI Desktop? Doing that will require a re-publish. Maybe update a database? 

or what you can do is save the PBI desktop file on OneDrive, and then you can set up a OneDrive refresh. 

 

Here's how you can do it:

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-powerbi-desktop-files/#where-your-file-is-saved-makes-a-difference

 

Then you can click on the dataset and schedule a refresh and choose "OneDrive refresh". That should work!

 

robgar's avatar
robgar
New Member
9 years ago

Thanks!  I edit in PIB Desktpo beasue it's more suitable for the changes I need to make.  Following your link seems promising and I have set it up that way.  I suspect I'm good to go.  Thanks!