Edit Personal Gateway?

[Betsy]

Hi Everyone,

I have raw data that is dumped to a dropbox folder, which I have connected to the service with a personal gateway. Someone else in my company moved the data, when I was working on desktop. Something happened where my desktop data source setting reset to a previous source path, and somehow my gateway was also changed. I can pretty easily change the source in my desktop files, but can I edit the gateway? I only see the option to remove it (I've also always wondered if there is somewhere to see where my gateway points to after I have set it up). When I went to remove it. it said that my dashboards will also be removed. Is this the case? I have almost 300 dashboards that are created from reports in various desktop pbix files that all have the same raw data source. It will take me a week to re-pin them all and reset up the apps that hold them. 

Thanks!

Betsy

[v-qiuyu-msft · Accepted solution]

Hi @Betsy,

From your description, it seems that you run the On-premises data gateway (personal mode), right?

After the report publish to service, configure the dataset to use On-premises data gateway (personal mode), then we will need to enter credentials like in desktop as well.  It means, though we change the source path in desktop then republish, as long as the machine hosts On-premises data gateway (personal mode) can reach the source, we needn't to made any change of On-premises data gateway (personal mode), we just need to enter credential again for the dataset.

While if you use the on-premise data gateway, after the source path change in desktop and publish to service, we need to create corresponding data source in data gateway to make the data gateway available for the dataset.

On-premises data gateway (personal mode) acts as a bridge between the data source and Power BI service. Remove On-premises data gateway (personal mode) will not delete any dashboard, report or dataset, just affect the dataset refresh.

Best Regards,
Qiuyun Yu