How to use the Excel Buffer in Business Central cloud

A week ago, my friend Daniel asked a question on Twitter how to use the Excel Buffer to export data with Business Central online. Many functions on the Excel Buffer are only available for on-prem. When you change the target in app.json to ‘Cloud’ then those functions become unavailable.

Luckily I had a code example available so I decided to put that on GitHub. But I thought it would make sense to write a blog post to explain the code.

Source : Kauffmann @ Dynamics 365 Business Central
Read more…

How To: Update an Existing Excel File in Microsoft Dynamics Business Central Online – Part 3 of a 4-Part Series

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.

Source : ArcherPoint
Read more…

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

Source : Evolution Business Systems
Read more…

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.

Source :
Read more…

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

Bron : Chris Webb’s BI Blog
Lees meer…