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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Avits ,

 

In my understanding, you need external users to be able to see the latest data. You have mentioned using SQL Server,you can configure gateway connection for it using direct query connection mode. So that the users can get the latest data when they do the interaction.

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • Avits's avatar
    Avits
    Regular Visitor
    2 years ago

    Hi Scott,

     

    You are right, and that is how we started.  Unfortunately, we needed some Dax Script in columns and this meant we had to import the data.