Reply
Highlighted
Member
Posts: 62
Registered: ‎01-13-2016

Power BI embedded supports data refresh

[ Edited ]

Does anyone know how Power BI Embedded supports data refresh or schedule for data refresh on "Data Import" mode? I am not using direct query.

 

The main reason is we are using Power BI service with data refresh scheduling, now power BI embedded comes out with lots of pros: simplify authentication, no Office 365, no Azure AD Sync, connection string can be changed programmatically, cost saving. So we really want to try this.

 

Plus, is there any limitation on the file size when importing like Power BI Service, 250M per file?

 

 

Regular Visitor
Posts: 24
Registered: ‎03-24-2016

Re: Power BI embedded supports data refresh

I have not found anything to refresh or set schedule in API unless you use Direct Query.  Review API once more and try options to be sure.

 

It is definitely a step in right direction but many features are missing and would soon need to be there for it to become compelling option against competitors.

Regular Visitor
Posts: 19
Registered: ‎10-24-2015

Re: Power BI embedded supports data refresh

It appears that you have to refresh the PBIX file manually and re-import each time you have updated data.  Hopefully this is just a limitation of the preview version.  It's disappointing that they went this direction, rather than allowing you to reference reports and data sets that have previously been published to the powerbi.com site. They already have the support there for scheduled refreshes, gateways etc.  Hopefully this is offerred as a solution going forward.

Power BI Team
Posts: 53
Registered: ‎01-08-2016

Re: Power BI embedded supports data refresh

Currently direct query is all we support in terms of refresh. Cached refresh support is certainly on our backlog as well as pushing data. As one of the previous posts suggests, you could update the file manually and re-upload it as a workaround for now.

Regular Visitor
Posts: 18
Registered: ‎04-06-2016

Re: Power BI embedded supports data refresh

In the meantime what about adding a switch to BPIDesktop.exe so this could be automated?  Something like:

 

BPIDesktop.exe c:\myreport.pbix -refresh

 

The 'idea' for cached refresh...

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13892673-allow-in-place-data-mode...

 

 

 

Regular Visitor
Posts: 33
Registered: ‎04-28-2016

Re: Power BI embedded supports data refresh

Is there a way to automate the updating of the pbix file?  I can automate the removal and relacement of the published pbix file, but can't find a way to build it automaically.  Can this be done in VBA?

Regular Visitor
Posts: 43
Registered: ‎10-03-2015

Re: Power BI embedded supports data refresh

Any Progress on progromatic data refresh for embedded now that we have GA?

Frequent Visitor
Posts: 4
Registered: ‎08-08-2016

Re: Power BI embedded supports data refresh

I'm using DirectSQL and takes 1 hour to update the dashboard on embedded version. I believe it is a Microsoft purposeful limitation.

Frequent Visitor
Posts: 4
Registered: ‎08-08-2016

Re: Power BI embedded supports data refresh

I'm using DirectSQL and takes 1 hour to update the dashboard on embedded version. I believe it is a Microsoft purposeful limitation.

New Member
Posts: 1
Registered: ‎04-07-2016

Re: Power BI embedded supports data refresh

Has anyone come up with a way to automatically refresh PBI Embedded report/workspace?  Any ETA on possible solution?