Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Desktop vs Service and data refresh from source files in OneDrive for Business

I use Power BI desktop to create my reports. I have a Power BI Pro subscription. I have the data gateway running on my server.   I store all of my source data in OneDrive for Business (and the PBIX...
Need Help
MattAllington's avatar
MattAllington
Community Champion
9 years ago

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. 

jmdh's avatar
jmdh
Advocate IV
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.