Microsoft Dynamics 365 Business Management Solution Enthusiast
7. November 2022 1 Comment
The export to data lake feature in Dynamics 365 Finance & SCM allows you to export data from tables to a storage account. You can directly export tables like CustTable, InventTable, etc. and do not need to put it in entities. Power BI can directly access the datalake and load D365 tables like in the good old times. I’ve published a short video on Youtube:
8. June 2022 Leave a comment
Ukraine is suffering under a brutal Russian aggression. Not everyone can fight a battle but everyone can help. Donate Bitcoin, Ethereum, Dodge etc. and help Ukraine to defend themselves.
4. May 2020 Leave a comment
A typical challenge in a BI project is to integrate data from different sources. For example files stored locally, ERP databases, cloud services, etc. On the other hand, PowerBI (desktop) is designed for power users to develop reports quickly. However, power users may have business knowledge but in most cases lack the technical knowledge to integrate all the data they need. With PowerBI dataflow it is possible to break the workload into a technical IT-related part and a business analysis part.
PowerBI dataflow hides the complexity of integrating differnt data sources, but provides an ready-to-use data source for PowerBI desktop. I’ve recorded a video how to integrate Excel expenses from a local folder with Dynamics 365 Sales customers and promote result as certified data source. The power user accesses this promoted data source in the report.
8. May 2019 Leave a comment
Like requested by some folks, I’ve added the .xpo file for the SSRS Report Mailer in the source code folder: https://erpcoder.blog/source-code/
Don’t get confused, the folders name is “Dynamics 365” but the XPO is for AX 2012
16. July 2018 1 Comment
I’ve created a video tutorial how to configure PowerBI on a stand alone Dynamics 365 Finance and Operations developer VM
ErpCoder 