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 moreTwo 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 morePower Query’s access to so-called “native queries” is often denied. In this short article I show how this limitation can be overcome.
Read moreEncrypting values such as credit card numbers, insurance numbers or account numbers is also possible with Power BI. The article shows how this works.
Read moreHits: 16119You have created a Power BI data model and want to import the data from Power BI Desktop into
Read moreHits: 34328The following article was written on the occasion of a Power BI User Meeting. It certainly makes more sense
Read moreHits: 6233Do you live in an ideal world, where data is always clean and correct? Or does your company have
Read moreHits: 104881This article “Seven types of table joins” was written in preparation for a user training and I don’t want
Read moreHits: 25596In this short article, I’ll show you how to use Power Query and Power BI to populate values with
Read moreHits: 2353If you want to perform calculations in Power Query, usually you have to add a new column and delete
Read more