Forum Discussion
Data set refresh for external user with viewer access
Hey Avits ,
To refresh the Semantic Model, you are right in your original thought, they have to have the rights to refresh the model itself in the workspace. And, you are right that they would need "contributor" access to do that.
However, you could create a PowerAutomate that use the API to call a refresh. Specifically, it would be this one (Refresh Dataset): Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Maybe I am getting the terminology wrong. The refresh I am talking about is indeed the one you refer to on the dashboar and I guess the fact is the data set in the semantic model has not changed, so no change for the user.
Yes, we can set up an automatic refresh, but the usage is fairly ad hoc. We did originally set up hourly refreshes, but there are a lot!
We got a bit worried about the level of transactions (not sure if there is a billing charge for that) and the load on the sql server.
It seems we have to allow the users to refresh the semantic model. In which case I was hoping to be able to set up a button to do that, but can't see how.
Thanks for the input.
Hey Avits ,
To refresh the Semantic Model, you are right in your original thought, they have to have the rights to refresh the model itself in the workspace. And, you are right that they would need "contributor" access to do that.
However, you could create a PowerAutomate that use the API to call a refresh. Specifically, it would be this one (Refresh Dataset): Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Thanks.
I may try that as an option at some point.
Right now, we are trying the Power Automate option. Seems ok so far.
Question: If I used the REST API would it still mean the user has to be a contributor or would viewer access be sufficient?