topic Re: Power BI embedded supports data refresh in Developer

Power BI embedded supports data refresh

cuongle — Wed, 13 Apr 2016 21:27:57 GMT

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?

Re: Power BI embedded supports data refresh

pritesho — Wed, 13 Apr 2016 22:23:29 GMT

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.

Re: Power BI embedded supports data refresh

jcapezzuto — Thu, 26 May 2016 15:19:41 GMT

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.

Re: Power BI embedded supports data refresh

jocaplan-MSFT — Thu, 26 May 2016 16:45:38 GMT

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.

Re: Power BI embedded supports data refresh

mhardy — Tue, 07 Jun 2016 01:35:55 GMT

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-model-refresh-in-embedded-powe

Re: Power BI embedded supports data refresh

DrBiker — Tue, 28 Jun 2016 10:40:50 GMT

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?

Re: Power BI embedded supports data refresh

SHHargrove — Mon, 11 Jul 2016 13:22:18 GMT

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

Re: Power BI embedded supports data refresh

guilherme — Mon, 08 Aug 2016 13:23:55 GMT

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

Re: Power BI embedded supports data refresh

guilherme — Mon, 08 Aug 2016 13:27:55 GMT

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

Re: Power BI embedded supports data refresh

ralph_schroeder — Wed, 17 Aug 2016 04:34:10 GMT

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

Re: Power BI embedded supports data refresh

vijayashanti — Thu, 18 Aug 2016 06:35:26 GMT

We had embedded power bi report into our web application & successfully applied row level security. now we are facing problem with data refresh, Power bi report which is been used for this is built with import query as direct query is not feasible for our application. Major Ask, How to refresh power bi report available in embedded workspace ? Do we have any utility built perform it

Re: Power BI embedded supports data refresh

Zwakele — Mon, 24 Oct 2016 09:32:34 GMT

Have you had any luck with this? I have the same problem. When I go to PowerBI report or Dataset it's updated but not on my embedded SharePoint Page

Re: Power BI embedded supports data refresh

derecskey — Mon, 24 Oct 2016 18:27:44 GMT

When will this must-have feature be released?

Re: Power BI embedded supports data refresh

vijayashanti — Tue, 25 Oct 2016 05:24:33 GMT

With direct query we can achive data refresh in embedded, but with import query still we are looking.

Re: Power BI embedded supports data refresh

benmek — Tue, 08 Nov 2016 15:38:37 GMT

ETA to support it?

Re: Power BI embedded supports data refresh

benmek — Tue, 08 Nov 2016 15:40:09 GMT

ETA?

Re: Power BI embedded supports data refresh

DrBiker — Mon, 14 Nov 2016 07:20:31 GMT

I am currently doing it with key-press emulation; works most days but somethimes fails when there is a change

Re: Power BI embedded supports data refresh

JorgeDiego — Tue, 03 Jan 2017 15:52:01 GMT

Hi,

Is there any new on this discussion?

I´m using Power BI embedded with direct query reports, but they are very slow because of many complex queries. I have tried to use import data and they are working better but I need to be able to refresh the data.

Does any one know how to do that?

Many thanks in advance.

Re: Power BI embedded supports data refresh

akahsin — Sun, 15 Jan 2017 20:07:58 GMT

I have the same problem. I am using import query and cannot ask the customers to regenerate the report daily and upload. Is there a way either to automate that process or refresh the data? Tx.

Re: Power BI embedded supports data refresh

Anonymous — Wed, 18 Jan 2017 16:55:21 GMT

Same issue here with my customers.

I have been told that Live Connection on SSAS through the gateway will be supported soon ... this could be a solution.