This post is really just a quick follow-on from my post earlier this week on using Process Monitor to troubleshoot Power Query performance issues with file-based data sources, which I suggest you read before carrying on. I realised, after playing around with Process Monitor some more, that the ReadFile operation actually tells you how much data is being read from a file when a Power Query query is running.
Troubleshooting Power Query performance issues in Power BI and Excel can be difficult because it’s a bit of a black box: there’s nothing in the UI to tell you what’s going on inside the Power Query engine and the diagnostic logs are very difficult to interpret.
The Physical Inventory Process is a fairly straight-forward function within Dynamics NAV with most companies adding their own specific nuances to meet the unique needs of their company. In this latest installment of our NAV Coffee Break video series, Gwen provides a foundation of the process.