New Generation Finance – Accounting – Controlling using Microsoft BI stack

  • Home
  • Learning resources
  • Speed/Performance aspects
  • About The BIccountant
  • Imprint
  • Datenschutz/Privacy

Archives

The BIccountant

New Generation Finance,  Accounting & Controlling using Microsoft BI stack

Business inquiries

info@thebiccountant.com

Log In

Categories

  • Accounting (21)
  • Allgemein (17)
  • Bug warning (3)
  • Charting (8)
  • Cube (7)
  • Data Modelling (10)
  • Dataflow (3)
  • Dataflows (5)
  • DAX (21)
  • Excel (86)
  • Finance (6)
  • Flow (6)
  • Function (23)
  • little Tipps&Tricks (41)
  • M (115)
  • nerdy (9)
  • Power Automate (4)
  • Power BI (153)
  • Power Pivot (27)
  • Power Query (155)
  • Python (1)
  • R (9)
  • SQL (1)
  • SSAS (6)
  • Tools (7)

Search by tag

Accounting Cube DAX Excel Finance Flow Function JSON M Performance pivot PowerBI Power BI Power Pivot PowerQuery Power Query R SSAS Text transformation Tools
  • Menu
  • Sidebar

Posts in Category ‘Allgemein’

Create (empty) table string from schema in Power Query

When your query returns an error, sometimes it could make sense to return an empty table instead of a simple error message. And ideally, this table has the same columns (…) Read more

  • 2022-05-12
  • Comment 1
  • Filed under: Allgemein

Why are Power Platform Dataflows adding steps automatically at the end?

Have you ever come across the case where you open your dataflow and find 2 additional steps at the end of your query? Why are Power Platform Dataflows adding steps (…) Read more

  • 2022-03-25
  • Comment 1
  • Filed under: Allgemein

Guest Post: Using List.Accumulate for Input/Output Genealogy

Foreword from Imke: Pat Mahoney is a very active fellow super user in the Power BI community and has a very strong interest in all things Power Query. He also (…) Read more

  • 2021-02-10
  • Comments 3
  • Filed under: Allgemein

Exception reporting and management for missing fuzzy matches in Power BI

In a previous article I have described how to use Fuzzy merge to match misspelled data to valid categories. With the sample data at hand, all values could be matched (…) Read more

  • 2021-01-19
  • Comments 4
  • Filed under: Allgemein

Split up an existing Power BI report into a Golden Dataset and a thin report

Edit 24thJune 2021: Unfortunately this method is currently not working any more. The other day I discovered a neat way to split up an existing Power BI report into a (…) Read more

  • 2020-09-17
  • Comments 6
  • Filed under: Allgemein

Performance tip for aggregations after joins in Power Query and Power BI

This article was edited on 2nd Nov 2019. JoinKind.Local has been removed to avoid problems with merges on tables with primary keys: In this article you’ll learn how to speed (…) Read more

  • 2019-10-28
  • Comments 7
  • Filed under: Allgemein, little Tipps&Tricks, M, Power BI, Power Query
← Older entries
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy / Datenschutzerklärung
  • © 2025
  • Powered by WordPress
  • Theme: Tatami by Elmastudio
Top

Follow me!

  • Twitter
  • YouTube
  • GitHub
  • LinkedIn
  • RSS Feed