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

Power BI Shared report Refreshing

Hi,

 

I have shared a report with my mate which was being scheduled refreshed by on-premise gateway on my account. Now, if my mate also want to refresh that shared dashboard/report to get the latest data as i get everyday. How he can achieve that?? Or as my dashboard/report is refreshed daily, will that be automatically reflect to the shared one on my mate's account??

 

Harsha

6 REPLIES 6
schaema3
Advocate II
Advocate II

I'm facing a similar issue. We are sharing a report among our team. All of us have pro licenses and sit on the same network. The report is available on the BI workspace for all of us. However, if you're hitting the refresh button on PowerBI Service it only refreshes the report if the owner of the file has refreshed it on PowerBI desktop and published it again. How can we get changes on the raw data side refreshed it fhat person is i.e. on holiday or not available to refresh and publish? We tried having the source data on a common SharePoint folder and also on a shared Onedrive. Both didn't work. Any suggestions?

I have the exact same issue as you.  Were you able to figure this out?

 

Thank you.

Hi Zamboni, no, we haven't figured out a smart way to do this. Only option that works so far is using a SharePoint side for the source data and a local copy of the report itself. This way every user that has the report can refresh it. It does work for small data volume but not if you're talking about millions of records.

Ok, thanks for your response.

 

v-shex-msft
Community Support
Community Support

HI @harshaSampath81,

 

I'd like to suggest you take a look at following links to know more about power bi sharing and refresh:

Share your Power BI dashboards and reports with coworkers and others

Data refresh in Power BI

 

Reports are load data from correspond dataset. So if you have finished configure dataset refresh settings(data source and gateway), it also means your reports will load latest data from that dataset.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hello Xiaoxin,

 

Those articles do not offer a solution for this problem.  The specific problem is this:

 

1.  I share my report with someone (we both have Pro).

2.  A new item is added to the original source data

3.  The person who I shared my report with clicks "Refresh", but the new data does not show on the report

4.  As owner of the report, I have to hit "Refresh" and then re=publish my report.  Then my co-worker can see the new information

 

We need a way for the co-worker to "Refresh" the report herself, without me having to do it and republish it each time.

 

Is this possible?

Thank you. 

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!