How to refresh a data set more 10 times a day.

[Sunkari]

My client is expecting his dataset should refreshed hourly, but i am seeing 8 times per day refresh restriction in link(https://powerbi.microsoft.com/en-us/pricing/).

How can i achieve this in my project

[DAN]

Hi @Sunkari,

Do you find an answer for your request? I'm working on it right now too...

Thanks,

DAN

P/s: and in case you have a link to vote about this pb, please send it to me, thanks 🙂

[waltheed]

Hi Sunkari,

That is currently not possible, but there are different ways to achive this.

1. Direct Query from Power BI to SQL Server 

Make sure you have small datasets going over and proper indexing. Then this should be OK.

2. Power BI Live connection to a tabular model, in Hybrid mode Tabular.

Ideal if not all data has to be "live".

More info: http://www.mssqlgirl.com/hybrid-mode-in-tabular-bi-semantic-model-part-1.html

3. You can also use Azure event hub and stream analytics if it has to be real-time. Your Power BI dashboards are updated real-time (!).

[kcantor]

@Sunkari You can refresh every 5 minutes if you want to.

http://www.powerpivotpro.com/2015/03/power-update-adds-email-notifications-macro-support-and-100-fre...

[DAN]

Hi @kcantor,

Could you please give me more details on "Power Update" please?

I checked your link, and it seems useful only for "Power Pivot workbook" (Power BI 's Excel version).

I thought that your answer is about refreshing the "Power BI Dashboard" based on "Datasets scheduled to refresh - every 5 minutes or more than 8 times per day".

=> I'm wondering about how "Power Update" can work with Power BI Desktop & Power BI Service?

Thanks,

DAN

[kcantor]

Power Update does indeed work with PowerBI. Here is another link that has a video showing real time updates with PowerBI so I believe it would meet your 5 minute requirement.

http://www.powerpivotpro.com/2015/02/introducing-power-update/

[DAN]

Thanksk kcantor,

The tool is cool but it's just a task plannificator..

It will replace the existing Power BI Dataset & Report => You will lost the link between dashboard and the replaced report..

I'm still looking for a new solution if you have..

Thanks for your time 🙂

DAN

[kcantor]

When creating my reports, I import the dataset and report to PowerBI. Then I use save as and leave a copy of the Pristine report on the site. My other reports are not replaced, just the pristine report. This works for me as I link the reports created using save as to my dashboards and they are never replaced.

[DAN]

@kcantor

Good job for the work around. I'll try this 🙂

Thanks,

[ankitpatira]

@Sunkari Unfortunately schedule refresh is only allowed 8 times a day. If you have requirement of update data you should consider options of DirectQuery or live connection.

[Sunkari]

Thanks for Reply.

If i use the direct connection to sql server database. There is any performance impact for reports.

How the query will executed, where the query will be prepared. If have some internal info, it will be very helpful for me.

Also how the data refresh will be performed, it is incremental or not.

[v-sihou-msft]

@Sunkari

Please submit a feature request on https://ideas.powerbi.com/forums/265200-power-bi-ideas. And we will also report it internally.

Regards,

[Seth_C_Bauer]

@Sunkari To add, the blog is older, so don't get confused by the order of operations. The choice for Import or Direct Query is on the initial pop up now as of the April update to PBI Desktop.

[ankitpatira]

@Sunkari Queries will be prepared in powerbi and sent to data source to be executed. There is no data refresh as you are connected live to the data source. Check out this blog that will give you example of how DirectQuery works. If you have proper indexing on data source (sql server) there should not be major performance issue.

http://www.en.seequality.net/tag/direct-query/