Forum Discussion

Avits's avatar
Avits
Regular Visitor
2 years ago
Solved

Data set refresh for external user with viewer access

A question from a relative newbie.   The refresh command on the PBI report implies it will refresh data, but I guess that does not mean the data set.   The only way I have found to make this work...
Need Help
  • collinq's avatar
    collinq
    2 years ago

    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

     

collinq's avatar
collinq
Super User
2 years ago

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

 

Avits's avatar
Avits
Regular Visitor
2 years ago

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?