Skip to main content

Power BI

Needs Votes

Auto refresh data in Power BI desktop

Vote (602) Share
Ezaz Ahamad's profile image

Ezaz Ahamad on 02 Aug 2016 15:29:23

There must be an option to refresh data through schedule in power bi desktop application. Please add this important feature.

Comments (87)
Ezaz Ahamad's profile image Profile Picture

8b79303c bb88-48b6-961a-99cf91751faa on 05 Jul 2020 23:15:59

RE: Auto refresh data in Power BI desktop

There are situations where PBI desktop can use a data source that the Power BI Report server cannot use - in this case it is necessary to have an auto refresh function in PBI desktop. Like I am facing in fetching ApInsight Telemetry in Power BI.

Ezaz Ahamad's profile image Profile Picture

18da6e44 ff8b-4044-ae1e-f2ca6fb134aa on 05 Jul 2020 23:14:41

RE: Auto refresh data in Power BI desktop

Really need to keep Desktop updated with Power Query of Excel to get valid scheduled updates in PBI service.

Ezaz Ahamad's profile image Profile Picture

98078bea 97d5-447a-8db0-731b0da59396 on 05 Jul 2020 23:13:21

RE: Auto refresh data in Power BI desktop

Desperately needed

Ezaz Ahamad's profile image Profile Picture

23829ea9 271b-49ff-b7e1-df50fed2b62d on 05 Jul 2020 23:06:19

RE: Auto refresh data in Power BI desktop

For near real-time On-premise data, Round trip to portal takes too long, requires an on-prem gateway, and currently doesn't allow for 2-5 minute refreshes. Ideally, I'd like a setting in Desktop that sends the Queries to On-premises sources and once all the data returns, send it again so I get as close to a real-time dashboard as possible but accounts for variations in network and database response speeds (dynamic). Please not something that is blinky on each update.

Ezaz Ahamad's profile image Profile Picture

777c7e05 5837-45df-8e95-83484785e72a on 05 Jul 2020 23:06:15

RE: Auto refresh data in Power BI desktop

Very important. As well because the dataload over Gateway is not always running!

Ezaz Ahamad's profile image Profile Picture

6e6309a9 6866-46d2-a74e-a69ac18ecd4c on 05 Jul 2020 23:06:14

RE: Auto refresh data in Power BI desktop

Yes this should really be part of the standard solution!! A schedule once per day is tbh useless.

Ezaz Ahamad's profile image Profile Picture

89de4180 eb1b-4b91-bd27-760b2d7df4bc on 05 Jul 2020 23:06:08

RE: Auto refresh data in Power BI desktop

Is it already done :-) ?

Ezaz Ahamad's profile image Profile Picture

36ba0e1f db65-46f4-8a40-98fc68cdf2eb on 05 Jul 2020 23:03:10

RE: Auto refresh data in Power BI desktop

Very important and powerful utility

Ezaz Ahamad's profile image Profile Picture

719c3f90 36cb-4b57-8c97-8b7fccbf7fdf on 05 Jul 2020 23:02:20

RE: Auto refresh data in Power BI desktop

Is there any way to do this with a Windows PowerShell script? Like a Python selenium for your desktop?

PowerBI doesn't have VBA like Excel. I would normally write, on open, refresh All.

Ezaz Ahamad's profile image Profile Picture

f3f0d403 6fb0-41a4-a69d-e10901ff277f on 05 Jul 2020 23:01:53

RE: Auto refresh data in Power BI desktop

This function is very important if PBI should be used professionally.