cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
SHDJason
Advocate II
Advocate II

Publish to Web refresh vs. dataset refresh

Hi, 

 

I'm hoping someone can explain to me how various refresh functions work. I want to be able to see changes reflected in my Power BI reports that have been Published to Web from an online data source. 

 

I have a report that connects to an online Sharepoint folder as the datasouce. I have been seeing that the updates to the files have not be showing in the reports.  These are the two parts that I am confused about:

 

  1. I added the refresh parameter to the report URL for Publish to Web, as we described in a different post. But does that pull all the way through to the original data source or does it only refresh from cached data?
  2. What role does the data refresh settings in the Power BI Dataset play? Currently, the dataset is set to refresh 2x per day. However, since it uses a direct connection to the Sharepoint files, does that matter?

Can anyone explain this? Thanks!  Jason 

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft
Microsoft

Hi @SHDJason ,


  1. I added the refresh parameter to the report URL for Publish to Web, as we described in a different post. But does that pull all the way through to the original data source or does it only refresh from cached data?

Updates to a report or visual take approximately one hour to be reflected in Publish to web embed codes. Reference: Updates to reports, and data refresh.

 


2. What role does the data refresh settings in the Power BI Dataset play? Currently, the dataset is set to refresh 2x per day. However, since it uses a direct connection to the Sharepoint files, does that matter?

For any data source being hosted online, any changes made are automatically updated in Power BI, usually within an hour. Refresh a dataset created from a .CSV file on OneDrive or SharePoint Online

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft
Microsoft

Hi @SHDJason ,


  1. I added the refresh parameter to the report URL for Publish to Web, as we described in a different post. But does that pull all the way through to the original data source or does it only refresh from cached data?

Updates to a report or visual take approximately one hour to be reflected in Publish to web embed codes. Reference: Updates to reports, and data refresh.

 


2. What role does the data refresh settings in the Power BI Dataset play? Currently, the dataset is set to refresh 2x per day. However, since it uses a direct connection to the Sharepoint files, does that matter?

For any data source being hosted online, any changes made are automatically updated in Power BI, usually within an hour. Refresh a dataset created from a .CSV file on OneDrive or SharePoint Online

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

Are there plans to change this? My DirectQuery data refreshes every 15 minutes in Power BI Service. I need to 'Publish to Web' but having an hour refresh makes the data obsolete to our users. It needs to be 15 minutes.

 

Thanks,

Dan

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors