Showing results for 
Search instead for 
Did you mean: 
New Member

visuals - a little automated

Hey the connoisseurs!


My question is how do I add a little automation to the visuals?
- my data source is in the form of an Excel spreadsheet, which can be accessed locally or on the web with a hyperlink;
- I imported these into Power BI with or without transformation and
- generates and publishes a visual based on it.


How can I now ensure that the visual changes according to the data contained in the data source?

Super User
Super User

Hi @webcat ,


You need to find the dataset for the published report in the Power BI Service and 'Schedule Refresh'.

Go to the workspace where your report is, hit the 'Datasets + dataflows' button, then hit the 'schedule refresh' button.




For an Excel file:

If your report uses the local Excel file as a source, you will need an Enterprise Gateway in order to authorise the PBI Service to access your network/machine to update the source.

If you use the web version of the Excel file as the source (SharePoint, OneDrive for Business etc.) then you will not need a gateway and MS will handle the access in the cloud.





Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

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!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors