Data Refresh working from Data set created in Service but not from Published Desktop Pbix

[jmdh]

I have an Excel file stored on OneDrive for business.

1) When i use it in desktop with Get Data>Excel and thenpublish to Service, the default Datset setting is going through my Personal Gateway.

2) When i access this same file from the service (Get Data > Files > Onedrive-Business ) the Dataset created is showing OneDrive Refresh ...and refreshes work like a dream

Can anyone explain?

On top of this the Default to the Gateway in 1) is an issue since i have uninstalled it but somehow it is still "seen" (and Microsoft support ihas been working on this other issue unsuccessfully for over 4 weeks)

[v-haibl-msft · Accepted solution]

@jmdh

Please get data through Web but not Excel as this document. Then you should be able to refresh without gateway.

After you uninstall the personal gateway, you still see it in Dataset setting but it should be displayed as offline. You can just ignore it.

Best Regards,

Herbert

[jmdh]

Many thanks.

It works and i had tried it.
However i believe that the documentation on Data refresh is very misleading and that the processs is incredibly cumbersome for new users.
For me the product should change and allow "onedrive like" connections as well as "local file " connections (a little bit like in the Service).

Documentation also states that the PBIx on Onedrive is refreshed hourly and i still have not seen it working...

Thanks again

Jmdh