Skip to content
Pardaan.com Pardaan.com

If your work becomes your passion…

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

Power Query

  • Home
  • Power Query
Posted inData & Analysis

Returning Annotations From OData Sources In Power BI/Power Query

The Power Query OData.Feed function has an option called IncludeAnnotations that allows you to return annotation values from an OData data source. It’s not obvious how to use it though – even if you use this option when connecting, you won’t see the annotation values by…
Read More
4 August 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
Posted inData & Analysis

Optimising The Performance Of Power Query Merges In Power BI, Part 3: Table.Join And SortMerge

When you merge data from two queries in the Power Query Editor the M code generated uses the Table.NestedJoin function. There is, however, another M function that can be used to merge data: Table.Join. The interesting thing about this function is that has a parameter that…
Read More
17 June 2020
Posted inData & Analysis

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 Source : Chris Webb's BI Blog Read more...
Read More
14 April 2020
Posted inData & Analysis

Adding Your Own Messages To Power Query Query Diagnostics

A quick point: while the Power Query Query Diagnostics functionality is relatively new, it’s based on Power BI/Power Query trace logging that has been around for a while. I’ve just realised that this means you can use the Diagnostics.Trace M function that I blogged about back…
Read More
4 March 2020
Posted inData & Analysis

An M Function To Help You Explore Power Query Diagnostics Data

Last week’s post showed an M function that took Power Query diagnostics data and formatted in a way that made it suitable for visualisation in a Power BI Decomposition Tree visual. This is great for understanding what’s going on at a high level, but by doing…
Read More
20 February 2020
Posted inData & Analysis

Remove Duplicates and Keep the Last Record with Power Query

Today I was helping a customer with a problem that seemed quite simple on the surface. She had a data table containing historical customer sales orders (each customer has many orders on different dates). The objective was to filter this table in Power Query and just…
Read More
17 February 2020

Posts pagination

1 2 3 4 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
  • 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
  • Fabric Copilot to help write DAX queries improvements
Scroll to Top