• 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

Power Query

Power Query in SSIS
Power Query SSIS 

Power Query in SSIS

14. May 201914. May 2019 Hans Peter Pfister 11 Comments #PowerQuery in SSIS, #SQL, #SSIS, PowerBI, Powerquery min read

Two years ago I wrote an article on how to export data from Power BI Desktop to an SQL database. Now there is another possibility which uses the possibilities of SSIS directly.

Read more
Power Query SSIS 

Executing Native Queries in Power Query

8. May 201914. May 2019 Hans Peter Pfister 0 Comments min read

Power Query’s access to so-called “native queries” is often denied. In this short article I show how this limitation can be overcome.

Read more
Encrypting Values in Power BI
M Power Query 

Encrypting Values in Power BI

22. February 201929. March 2019 Hans Peter Pfister 8 Comments min read

Encrypting values such as credit card numbers, insurance numbers or account numbers is also possible with Power BI. The article shows how this works.

Read more
Datan aus Power BI Desktop importieren
Export Data Power BI Desktop Power BI General Power Query 

Import data from Power BI Desktop into Excel

11. June 201829. March 2019 Hans Peter Pfister 0 Comments min read

Hits: 16119You have created a Power BI data model and want to import the data from Power BI Desktop into

Read more
Data Transforming Power Query 

Grouped running total in Power Query

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

Hits: 34328The 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: 6233Do 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: 104881This article “Seven types of table joins” was written in preparation for a user training and I don’t want

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: 25596In this short article, I’ll show you how to use Power Query and Power BI to populate values with

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: 2353If you want to perform calculations in Power Query, usually you have to add a new column and delete

Read more
  • ← Previous

Search

Newsletter

Statistik / Statistics

  • 0
  • 14
  • 5
  • 1,550,080
  • 706,692

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