Power Query in SSIS
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
Executing Native Queries in Power Query
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
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
Import data from Power BI Desktop into Excel
Hits: 16119You have created a Power BI data model and want to import the data from Power BI Desktop into
Read moreGrouped running total in Power Query
Hits: 34328The following article was written on the occasion of a Power BI User Meeting. It certainly makes more sense
Read moreBatch replacement of wrong values in Power Query
Hits: 6233Do you live in an ideal world, where data is always clean and correct? Or does your company have
Read more
Power BI – Seven Types of Table Joins
Hits: 104881This article “Seven types of table joins” was written in preparation for a user training and I don’t want
Read morePower Query – Adding leading zeros
Hits: 25596In this short article, I’ll show you how to use Power Query and Power BI to populate values with
Read moreIn column calculations
Hits: 2353If you want to perform calculations in Power Query, usually you have to add a new column and delete
Read more
