04-13-2016 02:17 PM - edited 04-13-2016 02:27 PM
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?
04-13-2016 03:23 PM
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.
05-26-2016 08:19 AM
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.
05-26-2016 09:45 AM
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.
06-06-2016 06:35 PM
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...
06-28-2016 03:40 AM
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?