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

Re: Power BI embedded supports data refresh

This is a huge need for our clients as well.  I saw this limitation in the PBI Preview but assumed something as fundamental as data refresh would be supported after the Preview.  Guess it's true what they say about assumptions.

 

Ideally we would have the ability to manage Power BI Embedded workspaces in the PBI Web App with the same ability to pull in PBIX files, set data refresh schedules on imported datasets, etc.  Sure, we can use an API to do some of the same things but why not just re-use that interface for PBI Embedded Collection Workspace Management??

 

Our reports refresh nightly for our clients - they need to see data change every day and there are lots of clients.  It is not practical for us to relegate this to a manual process.

 

The catch 22 here is that even if I wanted to re-write all of the scheduled data refresh logic myself (which I do not), I have no way to automate this right now because I can't programatically generate a PBIX file from a refreshed dashboard.   I can do everything needed after that: Use the API to import the file, use the API to set the connection credentials, get the embed URL, etc.  But I cannot get my automated hands on a refreshed PBIX!

I dug pretty deep this weekend into using Direct Query.  We use the hell out of calculated columns, measures and other things that simply go away with Direct Query.  Would involve a large amount of development spend to make our data warehouse look like how PBI has helped us evolve our visualizations and it becomes a big maintenance point.  Our business stakeholders are evolving how we look at the data in a very seamless way right now - this cannot go away and therefore, I feel DirectQuery is simply not an option for us.

Sure would love to hear from MS/a moderator on this particular subject.  This is huge for us...don't make me hunt you guys down at the upcoming Data Insights Summit.  To be truthful, I probably will anyways.  😉

 
UPDATE: Found this on the PBI Ideas list.  There are rumors in the comments that this will be released in Q2 2017.  It was needed Q4 2016 but beggars can't be choosers.

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

benmek Frequent Visitor
Frequent Visitor

Re: Power BI embedded supports data refresh

I was waiting for the release of this feature and DirectQuery option was slow. Finally, created an automation solution(C#) that opens the pbix file, click the refresh button. Once refresh is completed, it saves it and close Power BI desktop. Import the pbix to PowerBI embedded. 

Highlighted
hmokkapati Regular Visitor
Regular Visitor

Re: Power BI embedded supports data refresh

Anybody who knows if there is any update to this?

 

I need to pull data from API in the pbix file and need to show data as real-time as possible. This allows for 48 times refresh in a day (every 30 mins) even with Power BI Premium license.

 

If I go with Power BI embedded approach can I bring it down to 5 mins by any chance? Appreciate any pointers.

 

 

SuperTommy Frequent Visitor
Frequent Visitor

Re: Power BI embedded supports data refresh

Yes. This was implemented. See here, here and here.

otravers Member
Member

Re: Power BI embedded supports data refresh

But aren't programmatic refreshes triggered through the API constrained by the workspace capacity anyway (i.e. up to 8x or 48x per day)? It sounds like they are in the documentation:

https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/

thanosd Member
Member

Re: Power BI embedded supports data refresh

That's right @otravers.

Refreshes are constrained to 8 or 48 times per day based on the acquired capacity. If you exceed this limit, you get an exception "Number of refresh requests in last 24 hours exceeded limit". 

 

To add some more on this topic every refresh consumes part of the acquired capacity. So, you may face situations that a refresh (even for a small dataset) takes a long time waiting for some capacity to be assigned to it.

 

A feature that allow incremental refreshes  has already started and it would be nice addition to the refresh toolkit.

 

Hope this add to the conversation.

 

Regards,

 

Thanos

otravers Member
Member

Re: Power BI embedded supports data refresh

@thanosd Incremental Refresh is live as of today's Power BI Desktop update, but that's limited to PBI Premium:

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

 

I haven't heard of that functionality being planned for Embedded (which doesn't mean it's not, just that I haven't seen that explicitly mentioned, while it's been known for a couple of months that PBI Premium was about to get incremental refreshes).

thanosd Member
Member

Re: Power BI embedded supports data refresh

Hi @otravers,

 

some info from the internal teams was talking for being available for PBI Embedded (during summer). But maybe I haven't understand correctly.

 

I asked for some clarification. When I have something more on this, I'll get back to you.

 

Of course, you can still use this feature to embed reports with PBI Premium but you have to pay more (a lot more) 🙂

 

Regards,

 

Thanos

thanosd Member
Member

Re: Power BI embedded supports data refresh

Hi @otravers,

 

just to let you know that the incremental refresh will work with either dedicated capacity - whether that is from Office (Premium) or Azure (Power BI Embedded). 

This is the answer I've got from GuyInACube in my question in this video.

 

Hope it helps.

 

Regards,

 

Thanos

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 272 members 2,625 guests
Please welcome our newest community members: