Skip to content
Pardaan.com Pardaan.com

If your work becomes your passion…

  • Home
  • Profile
  • Tags
  • LinkedIn
  • Facebook
  • X

excel

  • Home
  • excel
  • Page 3
Posted inDynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: Save report dataset to Excel from the request page (Report Inspector)

As you might know, in Business Central and NAV windows client, we can view and save the report dataset from the preview page, similar to the page inspector. For the development of complex reports, it is very important to be able to analyze the data before…
Read More
13 July 2021
Posted inDynamics NAV & BC Tips & tricks

How to import Excel files using Excel Buffer

Last week, I saw a question about importing data from Excel file to Business Central using AL Language. A few years ago, the only solution was to use DotNet integration. However, with the Business Central, there is a much quicker and better approach. Source : Microsoft…
Read More
19 March 2021
Posted inDynamics NAV & BC Tips & tricks

Report Inspector 2.0 – How to export your report dataset as Excel, XML or Windows client style

Today’s post covers some programming that is not of my own making. My colleague Andreas Rascher has built a damn cool functionality that allows you to export the dataset of RDLC reports in different formats. Since we think the functionality is extremely useful, we didn’t want…
Read More
15 February 2021
Posted inDynamics NAV & BC Tips & tricks

Import data with the Excel Buffer

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. Source : Hougaard.com Read more...
Read More
25 November 2020
Posted inDynamics NAV & BC Tips & tricks

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. Source…
Read More
5 October 2020
Posted inDynamics NAV & BC Tips & tricks

Import to Excel Data Report in Business Central

Import to Excel Data Report in Business Central Source : MADHDA Read more...
Read More
1 October 2020
Posted inData & Analysis

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? Source : Chris Webb's BI Blog…
Read More
31 July 2020

Posts pagination

Previous page 1 2 3 4 5 … 18 Next page

Menu
  • Profile
  • Tags
Categories
  • Data & Analysis
  • Dynamics NAV & BC
    • Functional
    • General
    • Technical
    • Tips & tricks
  • ERP general
  • Information management
  • Off-topic
  • Projectmanagement
  • Quote of the week
  • Visual C# / ASP.net
Stay Hungry, Stay Foolish
RSS Mibuso
  • How to call a procedure in Business Central from Power Automate
  • How to transfer custom field from service order , service line (items) to Warehouse Entry Table
  • Advice needed: Switching to AL-GO Github?
  • "all of your selections were processed" BC message
  • How to implement OIOUBL 2.1 in NAV 2017 (codeunit 13609)
  • Missing Codeunit 9998 and 9999 of Upgrade Routine NAV2017 to BC 14 Spring 19
  • How can I change my Mibuso E-mail address in my user profile?
  • Tenant Media
  • Amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry
  • GST calculation issue
  • To provide Vendor Payment Bank upload file
  • Deepinserts not working
  • Adding new field to Base App Drop down field group view
  • Adding a new lookup field with a TableRelation to CRM Integration Table
  • Appending to the end of a file - BC v14, C/AL
  • How to save an ANSI file from Business Central?
  • E-Mails gets send but not moved to table Sent E-Mail
  • A part of page 13 Email Editor is not shown for some users, but for others
  • How to get Hash Certificate as Base 64 String in MS BC SaaS
  • What are the best AI coding IDEs for AL code
RSS Dynamics NAV Team Blog
  • Get started with agents for finance: Learnings from 2025 Gartner® CFO & Finance Executive Conference
  • The power of proactive engagement in Dynamics 365 Contact Center
  • Seamless scheduling across time zones in Dynamics 365 Field Service
  • Explore migration options for Microsoft Dynamics GP and Microsoft Dynamics SL customers
  • Unlock the power of record routing with real-time analytics
  • Agentic CRM systems: Learnings from organizations making the switch
  • Under the Hood: Building an AI-Driven Storefront with Dynamics 365 Commerce 
  • AI-powered proactive engagement and conversational journeys with Microsoft Dynamics 365 in public preview
  • Improve contact center operations with shift-based routing
  • Intent-based routing transforms customer support with AI
RSS Power BI
  • Open and edit any semantic model with Power BI tools
  • Power BI June 2025 Feature Summary
  • What’s New in SQL Server 2025 Analysis Services
  • Now available: two new Copilot experiences
  • Your Road to Power BI Certification Starts Here
  • Power BI Report Server May 2025 Feature Summary
  • Power BI May 2025 Feature Summary
  • The next era of Copilot in Power BI: Chat with your Data (Preview)
  • Translytical task flows (Preview)
  • Deep dive into selection expressions for calculation groups
Scroll to Top