At the Microsoft Business Applications Summit, our popular Power Hour session features all the wacky, frequently unseemly, and generally funny things members of our product team have created with Power BI. We’re opening a contest and it’s your turn to show us the crazy things you can build with the flexibility of Power BI.

This post will help with streaming data set creation and the execution of a script to a push to Power BI from a complete pandas DataFrame in one request.

Is there a simple way to convert a timestamp in UTC to your local time zone in Power Query? Yes and no. Let’s find out what the options are.