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?
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.
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.
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.
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...
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?
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.