As a Power BI developer I know how Power Query makes it easy to get data from web sources, but I also know there are limits to what it can do. I can get data from tables on web pages, I can get data from web services, but when confronted with a website where you have to click a button to download a file there’s a problem.
Tag Archives: Export
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.
How To: Email an Exported File From Microsoft Dynamics Business Central Online – Part 4 of a 4-Part Series
Another very common scenario is to email a file instead of downloading it to the user. To run this scenario, you need to set up SMTP in your Dynamics Business Central database. This exercise assumes that the SMTP settings are ready.
Power BI: Export to PDF and On-Demand E-Mail Subscriptions Now Available
The first new feature is one that has long been a top customer ask – the ability to export your Power BI report as a PDF document. Now all users will have the ability to export their reports to either a PowerPoint presentation or PDF document.
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.
Export C/AL objects as AL from a database on a docker container on a remote host
As you might have figured in quite some sessions, threads and posts, I’m quite fond running docker images on a remote Hyper-V on my laptop. From the moment it was described by Arend Jan, I’m using it. In my opinion, it’s a much better way to run, because Windows Server is so much better in memory management as Windows 10 is (in regards of Docker that is).
Style Sheet Export to Excel vs IndentationControls
The IndentationControls property is widely used to generate indented Tree View pages, and you can learn about it here: https://docs.microsoft.com/en-us/dynamics-nav/indentationcontrols-property.
In some scenarios, where you need more flexibility and dynamically populate the tree view, you would set the page property ShowAsTree to FALSE and disable the Excel Add-In to fall back to the original Style Sheet Excel export.