Using Process Monitor To Find Out How Much Data Power Query Reads From A File

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.

Bron : Chris Webb’s BI Blog
Lees meer…

Using Process Monitor To Troubleshoot Power Query Performance Issues With File Data Sources

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.

Bron : Chris Webb’s BI Blog
Lees meer…

Dynamics NAV Coffee Break: Physical Inventory Process

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.

Bron : ArcherPoint
Lees meer…