This blog series discusses each of those tasks. Part 1 explained how to export a file to Excel and download it, while Part 2 discussed uploading a file and storing it in a table. This blog explains how to update an existing Excel file.
Tag Archives: excel
Bulk Edit and Add Customers via Excel in Dynamics 365 Business Central
Manually adding or editing multiple customers to your database is frustrating, not to mention time-consuming. With the new release of Business Central you now have the ability to bulk add and edit customers via Excel. Now that’s something to get excited about
Use Excel to create a permission set
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.
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.