Forum Discussion
onedrive refreshWITHOUT gateway
jmdh Anonymous
Just read through your thread as I had exactly the same question.
However, I was asking myself:
If I connect to data sources on OneDrive and I need to use PBI Desktop to do advanced data modeling,
I need to save the pbix file on OneDrive as well to be able to refresh in PBI service without a gateway, right?
Otherwise if I connect to the data source on OneDrive, have my pbix file on my desktop and I make changes in the pbix file, the changes won't be reflected in the service if I don't have a gateway installed...?
Hi,
Basically (and i spent a lot of hours on this) there are two ways to manage Refresh when the source is Excel files.
1) Publish From the Desktop :
you need to access your Excel files (stored on OneDrive / sharePoint) in WEB mode ,
then Publish to PowerBI.Com,
then make sure in the Dataset which is automatically created to check the boxes on refresh etc
However each time you change your PBix, you need to Re Publish
2) Publish from POwerBI.Com
Access your PBIx file from PowerBI.Com
Your Pbix will be automatically refreshed at regular intervals (1hour i think)
I have not done it for a while but i think you also need to check the bowes to also Refresh your dataset
This is a summary, there is more to it. If you need more, let me know.
Jmdh