Tag Archives: custom connector

  • Custom Connectors & we’re the Power BI leading pioneers in Panama

    A couple of things have happened within the last few days. In short:

    • We have a new promo video
    • We published 3 Data Stories to the Power BI data stories gallery
    • Our Partner Showcase solution has been approved and published on the official Power BI website

    That’s A LOT of info to digest, but let’s get right into it.

  • First Impression on Power BI Incremental Refresh

    fireworks

    Power BI just recently released the ability to set up Incremental refresh policies through the Power BI Desktop.

    This is a short blog post with my first thoughts on it.

    Everybody has been excited about the possibility of doing Incremental Refresh through Power BI. Back in the day, this was only something that you could accomplish using Partitions in SSAS, which would require a server and it didn’t use M syntax at all.

    Recently there have been new releases like Azure Analysis Services and new versions of Analysis Services that have Power Query integrated into it which allow for really dynamic M syntax. To this point, everything was through a SSAS but now we have the ability to basically create partitions through a Power BI Desktop model.

    I not only wanted to test this out by itself, but by combining it with my Custom Connectors. Could I create a scenario where I’m getting data from the WooCommerce API (using my Custom Connector from here) and set up an incremental refresh?

    Let’s find out.

  • 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.