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

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

Accepted Solutions
Highlighted
konstantinos Senior Member
Senior Member

Re: What are options for data refresh using Power BI Designer?

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
4 REPLIES 4
Highlighted
konstantinos Senior Member
Senior Member

Re: What are options for data refresh using Power BI Designer?

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
GB Frequent Visitor
Frequent Visitor

Re: What are options for data refresh using Power BI Designer?

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/ 

sqlchicken Frequent Visitor
Frequent Visitor

Re: What are options for data refresh using Power BI Designer?

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

amysmith Regular Visitor
Regular Visitor

Re: What are options for data refresh using Power BI Designer?