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 Tagged ‘PowerQuery’

Improve File Import from SharePoint in Power BI and Power Query

When you use the UI to import files from SharePoint, you’ll end up with the Sharepoint.Files function. This function can become fairly or super slow when you use it on (…) Read more

  • 2020-11-16
  • Comments 63
  • Filed under: Excel, Function, M, Power BI, Power Query

Remove repeating characters from a string in Power BI and Power Query

Repeating spaces often cause problems when cleaning up your data. My new function “Text.RemoveRepeatingCharacters” can come to the rescue here. Imagine you have a table like this: Challenge To further work with this (…) Read more

  • 2018-01-07
  • Comments 16
  • Filed under: Excel, M, Power BI, Power Query

Number.Mod rescue pack for Power BI and Power Query

If you use the M-function Number.Mod in Power BI or Power Query and expect the same result like in Excel or DAX, you are probably in good company. But if (…) Read more

  • 2017-09-13
  • Comment 1
  • Filed under: DAX, Excel, little Tipps&Tricks, M, Power BI, Power Query

How Power Query can return clickable hyperlinks with friendly names to Excel

When you use Power Query as an Excel-automation-tool rather than just to feed the data model, you might want to return clickable hyperlinks that carry friendly names. This doesn’t work out of (…) Read more

  • 2017-09-12
  • Comments 27
  • Filed under: Excel, little Tipps&Tricks, M, Power Query

How to open a complex JSON record in Power BI and Power Query

Today I’ll show you a very useful technique how to deal with a JSON record that contains a wild mixture of different elements like this: If you click on one (…) Read more

  • 2017-08-30
  • Comments 4
  • Filed under: Data Modelling, Excel, little Tipps&Tricks, M, Power BI, Power Pivot, Power Query

Tips and Tricks for R scripts in the query editor in Power BI

Especially if you are new to R, there are some things one needs to know to successfully run R-scripts in the query editor of Power BI. I will share them (…) Read more

  • 2017-08-25
  • Comments 11
  • Filed under: little Tipps&Tricks, M, Power BI, R
← 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
  • © 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...