Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
sqlchicken
Employee
Employee

What are options for data refresh using Power BI Designer?

From my understanding when you create a PBI dashboard in PBI Designer, you've essentially locked in data in model embedded in file so when you upload it's only a snapshot of data at time. Is the only way to get refresh by using Power Query/PowerPivot and uploading the workbook or will Designer support data refresh?

1 ACCEPTED SOLUTION
konstantinos
Memorable Member
Memorable Member

1. Yes you can refresh data from supported sources..Check this 

http://blogs.msdn.com/b/powerbi/archive/2015/06/22/announcing-refresh-support-for-power-bi-designer-...

 2. If you are connected to supported sources above & can scedule a refresh, try savinf and connect  the pbix file from  OneDrive business or personal , when it fetces the new data it will also refresh your data model with any new measures  and/or visuals from reports..

 

Tested & posted yesterday: https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-designer-data-model-visuals-815a11ab5eb6

 

Konstantinos Ioannou

View solution in original post

4 REPLIES 4
amysmith
Helper I
Helper I

GB
New Member

For unsupported data sources we have been using a 3rd party tool called Power Udpate to refresh our data.  We use it to connect to our power pivot/power query models that source from onprem data such as Multidimensional cubes and SQL databases. It's free to try....

 

http://www.powerpivotpro.com/2015/02/introducing-power-update/ 

Ah yes, forgot about Rob's (and team) awesome contribution. Thanks!

konstantinos
Memorable Member
Memorable Member

1. Yes you can refresh data from supported sources..Check this 

http://blogs.msdn.com/b/powerbi/archive/2015/06/22/announcing-refresh-support-for-power-bi-designer-...

 2. If you are connected to supported sources above & can scedule a refresh, try savinf and connect  the pbix file from  OneDrive business or personal , when it fetces the new data it will also refresh your data model with any new measures  and/or visuals from reports..

 

Tested & posted yesterday: https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-designer-data-model-visuals-815a11ab5eb6

 

Konstantinos Ioannou

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.