Incremental Refresh in Power BI: How to Make Dataset Refreshes 95% Faster*

*Results may vary Summary What is incremental refresh in Power BI? Why would you use incremental refresh? Why wouldn’t you use incremental refresh? How to set up incremental refresh What is incremental refresh in Power BI? Behind every Power BI dataset is a SQL Server Analysis Services (SSAS) tabular data model. This underlying technology has built-in partition support for larger datasets. Partitions divide tables into…

Creating a Python Forecasting App with Streamlit and Prophet

I recently cobbled together a data web app using the Streamlit open-source framework. Users can upload their own data, visualize trends and features, and finally download the newly created forecast back to their computer. If you want to try it out yourself, you can see it in action here, assuming I have not gone over 25 hours of free app time on Heroku 😂 Streamlit…

Why You Should Choose Power BI Pro or Premium over Power BI Report Server

Introduction In this article I’ll share the top issues and missing features of Power BI Report Server (PBIRS), and explain why I think organizations should choose cloud versions of Power BI over the on-premises PBIRS. *as of May 2020 – features may change over time. To begin with, what is PowerBI.com vs. Power BI Report Server? Microsoft offers free, Pro, and Premium licensing options for…

Q&A in Power BI

Enabling Self-Serve Analytics with Q&A in Power BI

Hey everyone, Today I want to talk about Q&A in Power BI. Imagine typing a question like “what were sales in 2019?” and instantly getting an answer. This is actually already possible to implement in Power BI, and in this video I’ll show you how to set it up yourself. This seems to be a lesser known feature of Power BI, but it’s incredibly powerful…

Creating Interactive Python Visualizations With Plotly and Pandas

Jupyter notebooks make it incredibly easy to rapidly prototype vizualizations and work with data. In this example I wanted to show how you can also make interactive data vizualizations with the Plotly Python library. For the data sourcing and transformations I will use pandas library. I was absolutely blown away with how little code it took for me to set up some more advanced interactive…

Create Power BI Data Alerts

Creating Data Alerts in Power BI

Hey everyone, another quick video today! This time I wanted to showcase how you can set up automated data alerts in Power BI. Once you set these up, you will be notified by email and through the notification center on PowerBI.com when a KPI goes above or below a specific threshold. If you’d like more documentation on how to do this, please see the Microsoft…