Session Details

Session Details2019-01-07T06:21:08+00:00

Power BI Custom Data Connectors - Your Data, Delivered!

Presented by: Ryan Booz
Time: Friday, Jan. 11, 4:00 PM - 5:00 PM

Your company uses Power BI for many projects and reporting needs, and often you're the one who finds, gets and cleans the data in order to make it useful. Wouldn't it be better if you could create a plugin for Power BI that would enable them to import the data, pre-cleaned and ready to use?   This session will start with an overview of the Power Query (M) language used within Excel, Power BI and SSAS. From there I'll demonstrate how to use the Power Query SDK with Visual Studio to create a new plugin for Power BI Desktop, touching on what additional features are only available through Custom Data Connectors. I'll code an end-to-end example that pulls data from an external web service, adding features like custom authentication and navigation tables to make the data easily accessible to users. You'll leave this session with enough knowledge to create your first connector and solidify your superhero status in a data-hungry world.

Room: Portia / WisteriaTags: Functional Programming, OtherLevel: Intermediate