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 ‘Dataflow’

Quick fix for Formula.Firewall issues in Power Query and Power BI

Formula.Firewall issues can hit you when designing your queries or even “out of the blue” when suddenly refreshes in the service are failing due to changes in the query evaluation. (…) Read more

  • 2022-12-16
  • Comments 2
  • Filed under: Bug warning, Dataflow, Dataflows, Power BI, Power Query

Transforming multiple columns at once with reference to existing column in Power Query

In this article I’m going to present a method about transforming multiple columns at once in a fast way. This method also allows you to reference columns that exist in (…) Read more

  • 2022-02-20
  • Comments 12
  • Filed under: Dataflow, Function, M, Power BI, Power Query

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
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