Blog

  • Power Query and Excel files–XLSX vs XLS formats and datatypes

    image

    This is a topic that has been previously covered here by my good friend Ken Puls, but it was just recently that I found this response from Ehren about how Power Query interprets xls files differently to xlsx files and it is certainly worth a blog post to cover this in more detail.

    I highly encourage you to read this post if you use Power Query inside Excel or Power BI against Excel files either in *.xls or *.xlsx

  • Power BI Custom Connector Languages

    image

    Power BI Custom Connectors are something amazing and while they are still in a public preview phase, there are many things that are specific to custom connectors that go beyond what we used to know about M code.

    This post tries to cover how you can make your custom connector have a UI based on the language of your Power BI Desktop installation using the Extension.LoadString function.

    You can follow along by getting my Power BI REST API Custom Connector from here.

  • Guide and Resources for Web Data Extraction with Power BI & Power Query

    With the recent release of the Power Query Extensibility Model or Power BI Custom Connectors, I’ve been thinking about posting an article about the status of Web Scraping with Power BI / Power Query, its limitations and how Custom Connectors are here to provide the functionality that was restricted or limited to us within Power BI / Power Query.

    The goal of this blog post is to serve you as a guide on what you can accomplish with the native functionality of the ‘Web Data’ connector inside Power Query and when you should consider creating a Custom Connector.

  • The Ultimate Calendar Table Creator for Power BI

    Power Query and Power Pivot are AMAZING tools, but if you want to create a Calendar Table with either one of them, you’ll either have to learn how to code in M or DAX, or copy/paste a code that you probably found on the web like this one.

    The problem with that is that every time that you need to create a Calendar Table you need to go through that whole process, and going through either M or DAX code could be intimidating to even a seasoned player. There’s simply no easy or user-friendly interface or portability, but you STILL need a calendar table if you’re trying to use Power BI’s Time Intelligence functions.

    What if there was a single button that could create that Calendar Table for you?

    SNAGHTML456e89

    Imagine a button that sits right in the ‘Get Data’ window and once you click it, it’ll ask your for a few parameters like start date of your calendar table and, once you hit OK, you’ll get EXACTLY the calendar table that you were looking for?

    Well, this is now possible! and it’s all thanks to the Power BI Custom Connectors.

  • Roundup: New Custom Connectors and Videos

    For the past 8 weeks I’ve been focusing in exploring the Power Query Extensibility Model (PBI Custom Connectors) and I can confirm that the possibilities with this extensibility model are incredible.

    About Custom Connectors

    Custom Connectors not only bring new functionality to Power Query (like new data sources), but it also extends current functionality and can make some HUGE quality of life changes and improvements to the way we work with Power Query by creating custom connectors that act as function libraries.