cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lvanam Frequent Visitor
Frequent Visitor

Data refreshing

When I upload a PBIX file and create a dashboard by pinning visualizations to it and when I share teh dashboard, how will I share the data set behind it? For example, I created report with excel file on my local and uploaded it, Now, if I create dashboard out of it and share it with my manager and if I make changes to my local excel, how will they be able to refresh for changes? Will the dataset be shared by default as well? We have licenses for Power Bi desktop. Thank you for your answer.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Data refreshing

@lvanam It sounds like you are asking about the specific data refresh. You can schedule a refresh in app.powerbi.com by going to the dataset - > clicking on the "..." to the right of the data set name and scheduling a refresh. If you have a "Pro" license, you can schedule a refresh up to 8x per day. If you don't have "Pro" you can schedule 1x a day, provided your dataset is just a Excel tab (no pivot table/power query) - as this would require a gateway and thus a "Pro" license.

Depending on your scenerio, you can look here specifically, but you should be able to set up a refresh, so that when you update the file locally it will pull the information into the Dashboard and be visible to all end users.

Essentially, in this case, the dataset you see is the dataset the end user has access to see via the reports you built.


Near SE WI? Join our PUG Milwaukee Brew City PUG
2 REPLIES 2
Highlighted
CahabaData New Contributor
New Contributor

Re: Data refreshing

You will republish the PBIX file up to the PBI Service.

 

This will refresh the data on the dashboards.  In my trials of this I did discover a peculiarity with Win 10 Edge that it only refreshed once....and then stuck there despite republishing the the PBIX file.  But once I closed & reopened the PC it was displaying the refreshed data.  So presuming your users don't keep their Edge browser constantly opened on the dashboard there shouldn't be an update issue.  Not sure if this is Edge specific or could occur in other browsers..... didn't seem like a big deal so I didn't pursue it.

 

www.CahabaData.com
Super User
Super User

Re: Data refreshing

@lvanam It sounds like you are asking about the specific data refresh. You can schedule a refresh in app.powerbi.com by going to the dataset - > clicking on the "..." to the right of the data set name and scheduling a refresh. If you have a "Pro" license, you can schedule a refresh up to 8x per day. If you don't have "Pro" you can schedule 1x a day, provided your dataset is just a Excel tab (no pivot table/power query) - as this would require a gateway and thus a "Pro" license.

Depending on your scenerio, you can look here specifically, but you should be able to set up a refresh, so that when you update the file locally it will pull the information into the Dashboard and be visible to all end users.

Essentially, in this case, the dataset you see is the dataset the end user has access to see via the reports you built.


Near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 356 members 4,043 guests
Please welcome our newest community members: