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

Universal JSON-opener for Quandl in PowerBI and Excel/Power Query

Today I discovered JSON (…confess) and Quandl. Mates – this is powerful! Here comes just a quick function to automatically expand all columns of a time-series at once:

  • 2016-04-23
  • Comments 3
  • Filed under: Charting, Excel, little Tipps&Tricks, Power BI, Power Query

How to hack yourself in Power BI (and Power Pivot?)

Reading Gerhard Brueckl’s post on how to visualize SSAS calculation dependencies reminded me of my post about a similar technique from December last year. His solution has features that would do (…) Read more

  • 2016-04-09
  • Comments 23
  • Filed under: Excel, nerdy, Power BI, Power Pivot, Power Query

PowerBI Best Practice: Views for non-database data

Marco Russo has shared bunch of very valuable PowerBI best practice tricks for designing your PowerBI model here: http://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/?platform=hootsuite One of them being never to directly import a database table, but (…) Read more

  • 2016-04-01
  • Comments 0
  • Filed under: Excel, Power BI, Power Query
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
  • © 2025
  • Powered by WordPress
  • Theme: Tatami by Elmastudio
Top

Follow me!

  • Twitter
  • YouTube
  • GitHub
  • LinkedIn
  • RSS Feed