Forum Discussion
Desktop vs Service and data refresh from source files in OneDrive for Business
Matt,
Thank you. at this stage i still have no been able to have any autmatic refresh from Onedrive pro working.
I also have issues with the Gateway: the personal gateway didi not unsinstall properly and could not re install.
I Installed it on a second machine and it seems to have priority on anything else (ie the on prmise gateway installed on my own machne).
I XWill contact support at this stage or do you have any better idea?
Jmdh
jmdh, I've had a lot of trouble with the Gateway, too. I've installed and uninstalled it several times, always following the instructions here: https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-scheduled-refresh/
It's a mess, though. Sometimes app.powerbi.com will tell me the gateway isn't available when I know it is. And I've seen it update the data in a report even though it says the gateway is unavailable. It's been very finicky and unreliable.
Personal Gateway doesn't uninstall correctly - known issue. You should install the enterprise gateway. It is not difficult (as its name suggests) and has better support. It's shockingly easy, so just do it. Personal Gateway will still be there lying dormant as offline though.
Yes, i have also done this and it is easy as you say.
However, you then need to "activate" one by one each data source that you are using in your PowerBI desktop file which is both time consuming and frustrating since it has already been done in the PBI file itself.
Furthermore, it seems that once you have activated the gateway, it bypasses everything else, including the supposed automatic refresh from OneDrive.
I am waiting for support to come back to me on these topics.
Jmdh
Thanks, jmdh. I didn't know there was a known bug there but it makes sense.
I tried and tried to get the Enterprise gateway working but just couldn't get it to work. There were several things going, but one of the errors I saw repeatedly was in trying to add my data sources to the enterprise gateway. It would tell me that I couldn't add a folder becuase it was in use by another process. I wonder if that other process was the zombie personal gateway?
I ended up uninstalling again and setting up the Personal Gateway. I know it's not best practice, but it did at least work.
I'll be interested to hear what you find out from Support about this. I'll keep an eye on the thread.
Thanks again for your insight here.
