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

Using System Assigned Managed Identity for API imports into Azure SQL databases

For Azure SQL Databases there is a very cool new preview feature: “sp_invoke_external_rest_endpoint “. This function allows you to call certain Microsoft API endpoints directly from within your Azure database (…) Read more

  • 2023-03-27
  • Comments 2
  • Filed under: Power Automate, Power BI, SQL

“When a Power BI dataset refresh completes” trigger in Power Automate

If you have been working with Power BI for a while now you might have come across the standard Power BI actions in Power Automate. They allow you to automate (…) Read more

  • 2022-10-11
  • Comments 3
  • Filed under: Flow, Power Automate, Power BI

Create Power BI Metrics/Goals Scorecards from Excel files using Power Automate

I like Power BI scorecards a lot, as they give a really nice interface and look to your and your teams goals. However, entering all goals manually can become a (…) Read more

  • 2022-10-10
  • Comment 1
  • Filed under: Excel, Power Automate, Power BI

Recursive Flows in Power Automate – Introduction

If you want to traverse organisational hierarchies, walk through nested folder structures or create nested Power BI metrics from an Excel table for example, you need some sort of recursive (…) Read more

  • 2022-09-04
  • Comment 1
  • Filed under: Flow, Power Automate
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...