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 ‘Power BI’

Excel NORM.DIST function in Power Query and Power BI

If you’re looking for Excel functions in Power BI, you will recognize that much more of them have been transformed to native DAX functions than to native M functions in (…) Read more

  • 2021-12-26
  • Comments 7
  • Filed under: Excel, Function, M, Power BI, Power Query

Power BI Cleaner Gen2 now covers Analysis Services Models as well

Edit: I am retiring support for this tool for now, as you can find an alternative here: Measure Killer | Brunner BI. Please feel free to use this tool as (…) Read more

  • 2021-08-23
  • Comments 109
  • Filed under: M, Power BI, Power Query, Tools

Power BI Cleaner Gen2 is here

Edit: I am retiring support for this tool for now, as you can find an alternative here: Measure Killer | Brunner BI. Please feel free to use this tool as (…) Read more

  • 2021-06-27
  • Comments 47
  • Filed under: Power BI, Power Query, Tools

Fix error “..prod.powerquery.microsoft.com refused to connect” in Power BI dataflows

Today I could not edit any dataflows for a client and was constantly getting “… prod.powerquery.microsoft.com refused to connect”:   Twitterverse to the rescue After a couple of unsuccessful trials (…) Read more

  • 2021-05-12
  • Comments 0
  • Filed under: Bug warning, Dataflow, Dataflows, Power BI, Power Query

Power BI Cleaner now fully covers Calculation Groups

Edit: I am retiring support for this tool for now, as you can find an alternative here: Measure Killer | Brunner BI. Please feel free to use this tool as (…) Read more

  • 2021-03-06
  • Comments 3
  • Filed under: M, nerdy, Power BI, Power Query, Tools

Workaround to connect to Power BI dataflows from Power Query in Excel

Currently, we cannot connect to Power BI dataflows from Excel Power Query. And as we also cannot use custom connectors in there, we need a different alternative. I’m going to (…) Read more

  • 2021-01-24
  • Comments 8
  • Filed under: Dataflows, Excel, Function, 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
  • © 2025
  • Powered by WordPress
  • Theme: Tatami by Elmastudio
Top

Follow me!

  • Twitter
  • YouTube
  • GitHub
  • LinkedIn
  • RSS Feed
 

Loading Comments...