Use Patternchain in Power BI Desktop


Disclaimer: Microsoft is working hard to integrate Data Connectors to the Office Store. Until they do, please complete the following steps:

  1. Create a [My Documents]\Microsoft Power BI Desktop\Custom Connectors directory.

  2. Download Patternchain extension here and place it into the above-created directory.

  3. Enable the Custom data connectors preview feature in Power BI Desktop (under File | Options and settings | Options | Preview Features | Custom data connectors).

  4. Restart Power BI Desktop and click "Get Data". Select Patternchain (Beta) and click "Connect".

  5. Enter any amount just to load a hundred rows and click on "Edit Queries". From there, click on "Advanced Editor"

  6. Comment / Uncomment any of the Patternchain functions, change values as desired, and click "ok"

  7. VoilĂ ! Using Power Query (aka Language M), you have combined three Patternchain functions into a single table.

** Should you have any issues connecting to Patternchain, don't hesitate to contact us.