SSIS Archive - Power BI

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.

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.