In this video, I show an old favorite, the Excel Buffer. A great way to get data into Business Central. I create a few handy extra functions to make the experience nicer.
Tag Archives: excel
Business Central: Disable data export to Excel for secure data processing
Dynamics 365 Business Central allows you to export data from Business Central to Excel for further processing. In some companies, this function is difficult to perform due to certain data processing and monitoring regulations. Administrators can now manage the control of data export to Excel.
Import to Excel Data Report in Business Central
Import to Excel Data Report in Business Central
Adding Tooltips To Column Headers In The Power Query Editor In Power BI And Excel
Here’s something that will excite all you M nerds out there! Did you know you can make tooltips appear when you hover over column headers in a table in the Power Query Editor in either Power BI Desktop or Excel?
Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or Excel
One of the most common errors you’ll see when working with Power Query in Power BI or Excel is this:
Expression.Error: The key didn’t match any rows in the table
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.