Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
BrewedbyGemma
Frequent Visitor

Unable to assign users to Connection

Hello all, 

 

Relative PowerBI newbie here. Wonder if you can help. 

 

I'd like to assign manual refresh permissions on a dataset to a colleague. I've added the user as an Owner on the dataset. Currently they have the Refresh button in the Dataset, but the only option they see is 'Refresh history'.

 

Wondering if I also need to add them to the Connection? If this indeed the next step, I can't seem to assign anyone to a Connection. I choose the option, but then have nothing in the side panel (see screenshots). Is the ability to add users to a Connection perhaps an admin setting I need to ask for?

 

Thoughts gratefully received. 

 

Gateway add user.jpgGateway add user2.jpg

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Hi @BrewedbyGemma 

Adding users to the Gateway connection as in the screenshot won't allow users to refresh the dataset. Only one user who is the owner of the dataset can do it. You can't have multiple users as owners at the same time.

The owner must be a Member or Admin in the worksapce and take control of the dataset to become able to trigger a manual refresh

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

2 REPLIES 2
aj1973
Community Champion
Community Champion

Hi @BrewedbyGemma 

Adding users to the Gateway connection as in the screenshot won't allow users to refresh the dataset. Only one user who is the owner of the dataset can do it. You can't have multiple users as owners at the same time.

The owner must be a Member or Admin in the worksapce and take control of the dataset to become able to trigger a manual refresh

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thanks Amine, 

That's good to know. I've gotten around it with the scheduled data refreshes - should do the trick. 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.