When developing in AL creating permission sets isn’t the must fun thing to do…. I thought it must be possible to find a better tool than editing the xml file manually and found some inspiration here. Based on that I created this excel sheet that you can use to create a permission set xml file.
Tag Archives: excel
Data Privacy Settings And Data Refresh Performance In Excel And Power BI
I have known for a long time that data privacy checks can have an impact on the performance of data refresh in Power BI and Excel, but on a recent performance tuning engagement I had the chance to observe just how much of a difference changing these settings can make
Can You Use Power Query In Power BI Or Excel To Write Data To A Data Source?
It is, technically, possible to use Power Query (in either Power BI or Excel) to write data to a data source; for example, here’s an old post I wrote showing how to run a UPDATE statement to update data in a table in SQL Server.
Excel Buffer Patterns for Import or Update NAV Data from Excel Files
Today I want to present how to use Excel Buffer functionality in order to update/import data in NAV/D365 Business Central based on data from Excel files.
Applying Pivot Table in Excel using Automation Server Objects in NAV
In NAV when building a custom report that deals with totalling the amount by multiple G/L accounts by week then the report becomes tough to read as well as develop in standard SSRS Report. A possible and easy workaround is dumping all the entries in the Excel and performing the pivot table operation on the entries to give a precise results.
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.
Microsoft Business Applications sessions on-demand
Watch Microsoft Business Applications sessions on-demand to learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow and Excel are powering major transformations around the globe.