Data cache clean up in Microsoft Dynamics 365 F&SCM

In addition to the ways described here: https://gfeaxblog.wordpress.com/2017/12/14/ax-2012-clear-the-cache/

you have a couple of additional options to refresh the cache

#1 Run the class from browser

https://Environment name/?cmp=Company name&mi=SysClassRunner&cls=SysFlushAOD

Note: Please replace the text highlighted with your environment data

#2 Run Data cache clean up from the System parameters

System administration > Setup > Data cache > Data cache parameters > Cache refresh tab

PowerBI embedded in Tier1 and Tier2 environments

What is the proper way to access the data tables for Power BI in Production, Sandbox, etc?  

If you need to connect PowerBI to Microsoft Dynamics 365 for Finance and Operations you have several options depends on the environment that you are using.

Tier2 (PROD/UAT/TEST) or Tier1 (developer onebox)

• Tier2 environments have Azure SQL AXDW database which can be configured for automatic updates using System Administration > Entity Store > Refresh all cubes/measures. In that form you can setup update recurrence(some cubes you can update once a day, some once an hour). To access data in Tier2 you can use Direct Query. Direct Query connection to the cubes (AXDW database) is done through  Azure SQL database

Note: ODATA has access only to AXDB and does not have access to cubes, only to AXDB data.

• Tier1 environments have only SQL databases and that is real headache to configure PowerBI embedded for onebox environment. It requires external AXDW configured in Azure.