• How DAX calculates values
  • Power Query in SSIS
  • Executing Native Queries in Power Query
  • DAX Query Tables in Excel 2019
  • Use cases for Power BI Dataflows
Power BI

Power BI

Business Intelligence with Power BI

  • Online Kurse Power BI Coach
  • Table of Contents
  • About me
  • Speaking & Articles
  • German
  • English
Data Transforming Power Query 

Grouped running total in Power Query

2. June 201830. January 2019 Hans Peter Pfister 12 Comments min read

Hits: 34689The following article was written on the occasion of a Power BI User Meeting. It certainly makes more sense

Read more
Data Transforming Power Query Working with Columns 

Batch replacement of wrong values in Power Query

1. June 20183. June 2018 Hans Peter Pfister 4 Comments min read

Hits: 6256Do you live in an ideal world, where data is always clean and correct? Or does your company have

Read more
Combine Data Data Transforming Power Query 

Power BI – Seven Types of Table Joins

14. May 20183. June 2018 Hans Peter Pfister 7 Comments min read

Hits: 108086This article “Seven types of table joins” was written in preparation for a user training and I don’t want

Read more
DAX Row Level Security 

Power BI – Display Measures for specific users only

7. May 201824. September 2019 Hans Peter Pfister 1 Comment min read

Hits: 19730The use of user roles is an essential element for restricting or preventing access to the data. The following

Read more
DAX Measures 

Power BI – reduce the number of measures using color saturation

18. April 20183. June 2018 Hans Peter Pfister 0 Comments min read

Hits: 3139When displaying value changes over time, the past values, the current values and the planned values are often in

Read more
Data Transforming Power Query Working with Text 

Power Query – Adding leading zeros

29. March 201828. March 2019 Hans Peter Pfister 0 Comments min read

Hits: 25723In this short article, I’ll show you how to use Power Query and Power BI to populate values with

Read more
Power BI General 

Opening the same PowerBI file multiple times….

6. March 20183. June 2018 Hans Peter Pfister 2 Comments min read

Hits: 3579Today, I opened accidentally twice the same PBIX file. The standard behaviour would have been an error message, saying

Read more
Data Transforming Power Query Working with Columns 

In column calculations

7. February 20183. June 2018 Hans Peter Pfister 0 Comments min read

Hits: 2356If you want to perform calculations in Power Query, usually you have to add a new column and delete

Read more
Power BI General 

Export datasets from Power BI Service to CSV using VBA

29. September 201721. June 2018 Hans Peter Pfister 5 Comments min read

Hits: 12377Downloading a Power BI Dataset with VBA wasn’t really a thing I planned to do until Microsoft released the

Read more
  • ← Previous
  • Next →

Search

Newsletter

Statistik / Statistics

  • 3
  • 501
  • 344
  • 1,577,352
  • 725,931

Categories

  • DAX
    • Fundamentals
    • Measures
    • Row Level Security
  • Power BI General
    • Power BI Desktop
  • Power Query
    • Data Import
      • Internet
    • Data Transforming
      • Combine Data
      • Working with Columns
      • Working with Text
    • Export Data
    • M
    • Miscellaneous
  • SSIS

Recent Comments

  • Hans Peter Pfister on Creating multilingual reports in Power BI
  • Ricard Pascual Pijoan on Creating multilingual reports in Power BI
  • prill2taTroy on Grouped running total in Power Query
  • Hans Peter Pfister on Export data to SQL
  • Hans Peter Pfister on Creating multilingual reports in Power BI
  • Data protection statement
  • Imprint
  • About me
Copyright © 2016 - 2023 Power BI. All rights reserved.
  • German
  • English