Forum Discussion

tusmo's avatar
tusmo
Frequent Visitor
8 years ago

Let multiple people refresh dataset

Hi,

 

I have published a report to an App workspace and I've added other people as members to the workspace. The report gets data from an Azure SQL database. Currently if other users try to click "Refresh now" in the dataset they get an pop-up saying that they do not have the credentials to do that or something to that effect. They can "Take over" the dataset but then if I want to refresh it I have to take it over again.  Is there a way to setup the data source such that anyone who is a member in the workspace is able to easily refresh the data?

Need Help

10 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    8 years ago

    Hi tusmo,

     

    Based on my test, on the Users tab, for the data source, you can add, and remove, users, or security groups, that can use this data source. Then the user could refresh the dataset by himself  without any issue. For more details, please check the online document.

     

     

    Regards,

    Frank

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      What if your data sources are linked to SharePoint site?  Multiple users have access to the files including the PowerBI report. However, when we need to refresh it, it is still linked to the user that uploaded the file from sharepoint into Powerbi.  Only the user that uploads the data files can refresh the PowerBi report.  If the data files are saved and uploaded from a common location, we want anyone with access to those files to be able to refresh the report.  Is that possible?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

        I am having the same issue. I am linked to a SharePoint site and we need to give multiple users the ability to refresh the Power BI dashboard.
        Did you find a solution to this?

        Thanks,

        Chris

    • tusmo's avatar
      tusmo
      Frequent Visitor
      8 years ago

      If I'm understanding you correctly this requires me to set up a data gateway?

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        8 years ago

        Hi tusmo,

         

        What is your data source? As you description, I think for your data source, the gateway is required.

         

        Regards,

        Frank

    • noumanqaiser's avatar
      noumanqaiser
      Advocate I
      7 years ago

      Hello Frank, The solution you told applies to non-Azure SQl Databases, For Azure SQL Database you donot require any Gateway. Can you help clarify how to allow multiple users to refresh Azure SQL Datasources.