How to change user associated with a dataset?

[Clark]

I created a set of reports and dashboards with a dataset and it is associated with my personal O365 account instead of my work O365 account.  So, when I go into the refresh settings on the dataset to map it to my Enterprise Gateway, it tells me that it can only work with a personal gateway since my personal account doesn't have access to an Enterprise Gateway.

Is there a way to change the associated account to my work account without re-creating all my datasets and reports?

I have signed out and back in.  I have saved the file as a different name and published it again.  It is not an issue with the user associated for publishing, because it is publishing to the correct O365 subscription, it is just somehow embedded in the dataset.

Any help would be appreciated.

[dimazaid]

Hi @Clark,

The personal Gateway is associated to you not the dataset in this case. It will be the default choice if you don't have access to any other Enteprise Gateways. 

What you could do is : 

Option 1- Install an enterprise gateway by following this guidance: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/

Once you do this, you can add the data sources used in your data set from the Manage Gateways UI and you can use either account. 

Option 2 - Install another personal gateway on a different machine, but you have to make sure you are signed in as your work account on the machine where you install it. That way when you sign in to the PBI with your work account the new personal gateway will show up, and no need to re-associate the data sources.

Hope this helps!
Dimah 

[Clark]

I'm sorry, but this was not helpful.  I already have an enterprise gateway installed and working fine in my company O365 account.  For some reason, this dataset is associated with a different O365 subscription that doesn't have Power BI Pro, even though it resides in the subscription that does have Power BI Pro.  It makes no sense to me.  I'm not even sure where it got the user of "who" made the dataset.  I thought it might have to do with the fact that I was referencing some Excel files, so I made sure they were all saved in Sharepoint Online associated with the related O365 account.

I created all the data sources from scratch and published a sample report with these and it still associated the datasets with the incorrect user. 

[dimazaid]

You're using PBI Desktop, correct? Which account are you using for PBI Desktop? 

[Clark]

I'm signed in with the business account.

[Clark]

I think I found the issue.  When I remove references to Excel datasources saved in Sharepoint Online, it works fine.  That still doesn't solve the problem though.  I thought it was supposed to work with Excel / Sharepoint Datasources.  What am I missing?