This is another post based on a demo from my SQLSaturday session about Python integration in Power BI. The data file is also available from this link or download your own file from the Reserve Bank link below. It is…
Monthly Archives: September 2018
Unpivot Excel data with Python
This post is is based on another demo from my SQLSaturday session on Python integration in Power BI. Its a handy real world scenario that could easily be re-applied with minor changes to the script. The primary pattern is unpivot…
Power BI date table with Python
I spoke about Python integration in Power BI at SQLSaturday #793 in Cape Town this past weekend. You can download the deck (which includes the notes) and the Python scripts (which include sample data) from the SQLSaturday site. One of…
Python & Power BI: Load from SQL Server
This is part 4 of the Python integration in Power BI series. We are going to explore sourcing data from SQL Server (including Azure SQL DB). If you have been following the series, you would be familiar with the the…
 | Kyle W. Smith (@kwsS… on Loading JSON … it looks… |
 | Xin Yin Ooi on Loading JSON … it looks… |
 | asdasd on Unpivot Excel data with P… |
 | Python Examples on Basics of Python in Power… |
| Loading JSON …… on Loading JSON … it looks… |
Data Ideas 