The BIccountant

New Generation Finance – Accounting – Controlling using Microsoft BI stack

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

Archives

  • Menu
  • Sidebar

Posts in Category ‘little Tipps&Tricks’

How to cancel your Power Query refreshes fast in Power BI and Excel

If you’re working with large data or complex queries that take a long time refresh, cancelling one of those refreshes can even take longer time, especially, if the query has (…) Read more

  • 2019-04-27
  • Comments 3
  • Filed under: Excel, little Tipps&Tricks, M, Power BI, Power Query

Query folding on JoinKind.Inner gotcha for Power BI and Power Query

If you query databases who support query folding, you’re probably very aware of every step you take and check if folding happens with every new step like so: Folding will (…) Read more

  • 2019-04-18
  • Comments 0
  • Filed under: Allgemein, little Tipps&Tricks, M, Power BI, Power Query

Bulk-extract Power Query M-code from multiple Excel files at once

Some time ago I published a function that extracts all M-code from Power BI (.pbix)-files. Today I publish the pendant to Bulk-extract Power Query M-code from multiple Excel-files at once. (…) Read more

  • 2019-03-06
  • Comments 10
  • Filed under: Excel, little Tipps&Tricks, M, Power Query

Screenshot tutorial: Add a column with custom function code in Power Query

The following steps show how to create a new column in a table using existing custom function code. This works in Power BI as well as in Power Query in (…) Read more

  • 2019-01-30
  • Comments 2
  • Filed under: Excel, little Tipps&Tricks, M, Power BI, Power Query

Improve import of Excel sheets with empty rows and columns in Power Query and Power BI

When you import Excel sheets who have empty leading or trailing columns and rows (showing null-values), you can substantially improve the complexity and speed of your import process with a (…) Read more

  • 2018-07-28
  • Comments 3
  • Filed under: Excel, little Tipps&Tricks, M, Power BI, Power Query

Import data from multiple SharePoint lists at once in Power BI and Power Query

This is a quick walkthrough on how you can easily import multiple SharePoint lists at once, just like the import from folder method. Start as usual You start your import (…) Read more

  • 2018-05-22
  • Comments 2
  • Filed under: little Tipps&Tricks, M, Power BI, Power Query
← Older entries
Newer 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
  • © 2023 The BIccountant
  • Powered by WordPress
  • Theme: Tatami by Elmastudio
Top

The BIccountant

New Generation Finance,  Accounting & Controlling using Microsoft BI stack

Business inquiries

info@thebiccountant.com

Follow me!

  • Twitter
  • YouTube
  • GitHub
  • LinkedIn
  • RSS Feed

Log In

Categories

  • Accounting (24)
  • Allgemein (17)
  • Bug warning (3)
  • Charting (8)
  • Cube (7)
  • Data Modelling (11)
  • Dataflow (3)
  • Dataflows (5)
  • DAX (23)
  • Excel (89)
  • Finance (6)
  • Flow (6)
  • Function (22)
  • little Tipps&Tricks (41)
  • M (117)
  • nerdy (9)
  • Power Automate (3)
  • Power BI (154)
  • Power Pivot (29)
  • Power Query (157)
  • Python (1)
  • R (9)
  • SSAS (6)
  • Tools (7)

Search by tag

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

Loading Comments...