Business Central Online, quick comparison and detection of differences between table data structures using Powershell

Previously it was possible to export data structures to files (available in runtime1), the functionality was blocked from runtime 2 onwards.

Interesting function that in my opinion should be reinserted and made usable at least for On-premise.

Source : Roberto Stefanetti
Read more…

Comparing The Performance Of CSV And Excel Data Sources In Power Query

My posts from two weeks ago (see here and here) on using Process Monitor to troubleshoot the performance of Power Query queries made me wonder about another question: how does the performance of reading data from CSV files compare to the performance of reading data from Excel files? I think most experienced Power Query users in either Power BI or Excel know that Excel data sources perform pretty badly but I had never done any proper tests.

Bron : Chris Webb’s BI Blog
Lees meer…