📈 Zach Renwick
    • Posts
    • Azure
      • Sentiment Analysis
      • Twitter to Google Sheets Integration with Power Automate
    • Streamlit
      • Creating a Python Forecasting App with Streamlit and Prophet
    • Power BI
      • Incremental Refresh in Power BI
      • Power BI Report Server Limiations
      • Working with JSON Data in Power BI
    Hero Image
    Incremental Refresh in Power BI

    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 logical parts, which can then be refreshed independently. Incremental refresh brings that same partition support to the forefront in Power BI, enabling business users and IT professionals to refresh sections of a dataset. Why would you use incremental refresh in Power BI?

    March 16, 2021 Read
    Hero Image
    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 – these 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 Power BI in the cloud.

    May 10, 2020 Read
    Hero Image
    Working with JSON Data in Power BI

    In this article I’ll give a brief overview of how you can easily work with JSON formatted data in Power BI. To keep things interesting, we’ll create a simple listening history report from our JSON formatted Spotify data. The first step in our example will source your personal data from Spotify. To do this, log onto www.spotify.com, click on “Account”, and then go to your privacy settings: Next, scroll down to your personal data.

    February 16, 2019 Read
    Navigation
    • About
    • Skills
    • Experiences
    Contact me:
    • zach.renwick@gmail.com

    Toha Theme Logo Toha
    © 2020 Copyright.
    Powered by Hugo Logo