Refresh Dataset - Source Dataflow

[srdjanmish]

Hi Guys...

I have a problem, and a queston related to it...

I have organization and I created one Workspace where I make dataflows for my users, so they use it as source for datasets...

Dataflows are syncing regulary through gateway on my DB Server (every morning). My users can create dataset from my dataflows, but they can't schedule a refresh without gatweay credentials (that is what PBI says). I have an Idea not to give them DB access, and that is why I created Dataflows, so is there any way to set refresh to dataset, based on Dataflow source (no other datasources)? 

Other q is: If I take ownership of dataset, so I can schedule, will they be in position to reupload changed dataset (they maintain it)?

[Mariusz]

Hi @srdjanmish 

My understanding is that if you created the dataflows and users build reports on top of them, they will  not need 

gateway access as their data source is a dataflow and not your db, all you need to do is let them know when your refresh is done so they can schedule dataset refresh after.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[srdjanmish]

@Mariusz You are right... That is the plan.. Scenario should work like that... Can it be Done!?

[Mariusz]

Hi @srdjanmish 

Yes, you need to build you dataflows and share the workspace with the users, they should be able to access the data flows as below, build datasets on top of them and schedule the refresh of this dataset themselves.

The below article explains the process and more importantly the permissions.

https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[srdjanmish]

@Mariusz It is done that way. I created Workspace, shared it to users, created dataflows inside those workspaces, and they are creating Datasets based on dataflows. And, at the point of scheduling, it says that it needs gateway credentials....

Maybe some rights? Anyone?

[v-lid-msft · Accepted solution]

Hi @srdjanmish ,

Based on my test, if this dataset only contain dataflow, we did not need to configure gateway for it, but we need to sign in Power BI Service account, which have premission to this dataflow,  in setting of dataset. Could you please check if they have mixed other  data source with this dataflow in dataset?

Best regards,

[srdjanmish]

I found the problem, we have to authorize and determine type of dataset to enable refresh... Thanks for help...