How to auto refresh Power BI

[Anonymous]

I've got dynamic sheet which will auto refresh every 1 mins.  i found Power BI desktop can not auto refresh.  is there anyway i can auto refresh my dashboard? 

[gauravbi]

Not for dashboard but below is really great plug-in for report (Note : wont work in full screen mode) :
https://spgaurav.blogspot.com/2019/04/chrome-plugin-to-auto-refresh-power-bi.html

[Baskar]

Yes power BI Dashboard Tiles won't refresh automatically,

1. Pin your entire report to Dashboard , That will change every 15 mins once or refresh from dashboard and check it.

2. If u want live streaming dashboard . that also we can do in power BI. yes for this u have connect the source by API.

This API option only available in Power BI Service not in Desktop.

let me know if any doubts .

[Anonymous]

We are using Dynamic CRM, can I connect CRM and Power BI online for auto refresh or streamline? or still need API connection? 

[v-ljerr-msft]

Hi @Anonymous,

Yes, you can use Get Data to connect to and import your data from an online service provider like Dynamic CRM. Like most online service providers, Dynamic CRM updates data once a day, usually at night. You can manually refresh your Dynamic CRM dataset, or setup a refresh schedule, but it’s not necessary because Power BI will automatically refresh the dataset and your reports and dashboards will be updated too. For more details about Data refresh in Power BI, you can refer to this article.

However, if you want to create real-time dashboards in Power BI, you may need to make use of Microsoft Power BI REST API and Set up your real-time streaming dataset in Power BI. For more details, please refer to the following articles:

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-real-time-streaming/

https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-overview-of-power-bi-rest-api/

Regards

[Anonymous]

where to find "dynamic CRM" under get data?  there are "dynamic CRM marketing" and "service" content pack, but all failed and it've been told it's not working on CRM online 2016.  and some1 also said because the size over the limit.  any idea? 

[parry2k]

i found this link https://www.greenbeacon.com/insights/how-to-connect-power-bi-to-microsoft-dynamics-crm-online/

hope it is helpful.

Can you share what version of dynamics crm you are using, is it online or on-prem?

some more links

https://technet.microsoft.com/en-us/library/dn708055.aspx

http://community.powerbi.com/t5/Desktop/Scheduled-refresh-Odata-oauth2-Dynamics-CRM-Online-not-able-...

[Anonymous]

i can connect power desktop with dynamic crm online, then publish onto power bi service for auto refresh.  But i found it working with small datasets but not big ones.  auto refresh keep failing.   some1 said auto freshing not working with big datasets. 

[Anonymous]

We are using Dynamic CRM, can I connect CRM and Power BI online for auto refresh or streamline? or still need API connection? 

[BhaveshPatel]

Auto refresh is not supported in PowerBI Desktop but you can try the third party product Power Update to auto refresh your PBI Desktop file.