cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Enabling multiple users on source data stored on SharePoint

Hi,

 

The source data of my report comes from three excel files. The data in these files will be updated periodically. These files are stored on SharePoint.

 

Here's the requirement.
To enable few other users so they can do the data entry in the three excel files, and then update the Power BI report.

 

Here's what's happening

After they edit and save the excels and click refresh on the report, the report does not update. They all have read, reshare, build permission on the dataset.

 

How do I achieve this?

 

Note that

  • They don't have access to the .pbix file, but have access to the published report on the PBI Service.
  • I don't need a scheduled refresh on the report. The users should be able to manually refresh the report after they update the excel files.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Enabling multiple users on source data stored on SharePoint

Hi @Enigma ,

 

  1. Yes, you need to give them access to the workspace as well.
  2. Once  the owner of dataset set the credentials, all the members share it.
  3. First of all, when you refresh the dataset, the report will not immediately display the latest data before you refresh the report. Dataset refresh is a data source refresh to get the latest data. Since the power bi report caches the last state of the current visualization, the report refreshes, fetching the latest data from the dataset to the report.

 

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

 

Best Regards,

Dedmon Dai

View solution in original post

4 REPLIES 4
Highlighted
Helper II
Helper II

Re: Enabling multiple users on source data stored on SharePoint

Any ideas?

Is it mandatory to have a gateway installed for this purpose? The files are stored on SharePoint.

Highlighted
Microsoft
Microsoft

Re: Enabling multiple users on source data stored on SharePoint

Hi @Enigma ,

 

Would you please check the credentials and refresh history for it?

Untitled picture.png

And you should refresh the dataset before you refresh the report:

Untitled picture1.png

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

 

Best Regards,

Dedmon Dai

Highlighted
Helper II
Helper II

Re: Enabling multiple users on source data stored on SharePoint

Thanks @v-deddai1-msft 

 

Yes, there was an issue with the credentials. I reset them and the refresh started working.

I had a few more questions around this, though.

 

  1. If I want to allow my teammates to be able to refresh the dataset, is it necessary to give them access to the workspace as well? I had shared the report with them and gave them read, reshare and rebuild access. However, they could see only the report and not the dataset. Only when I gave them access to the workspace, could they see the dataset( and the refresh now option) as well.

  2. I could do the dataset refresh once I reset my credentials. But none of my team mates were asked for their credentials when they performed the dataset refresh. How does this work? Are credentials of only the dataset creator necessary?

  3. What is the difference between refreshing a report and refreshing a dataset? The .pbix file is stored on my local disk. But the source data (excel files) for the report is stored on SharePoint. In this context, what will each refresh do?

Thanks!

Highlighted
Microsoft
Microsoft

Re: Enabling multiple users on source data stored on SharePoint

Hi @Enigma ,

 

  1. Yes, you need to give them access to the workspace as well.
  2. Once  the owner of dataset set the credentials, all the members share it.
  3. First of all, when you refresh the dataset, the report will not immediately display the latest data before you refresh the report. Dataset refresh is a data source refresh to get the latest data. Since the power bi report caches the last state of the current visualization, the report refreshes, fetching the latest data from the dataset to the report.

 

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

 

Best Regards,

Dedmon Dai

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Kudoed Authors