Forum Discussion

phawrylak's avatar
phawrylak
New Member
3 years ago

How to implement views/dimensions in Power BI Desktop custom connector

Hi all,

I'm currently working on a custom connector for Power BI Desktop and trying to implement navigation tables. I would like to achieve a similar result as in the Google Analytics connector, where we can find predefined views and extend the range of columns by selecting additional dimensions. Requests with a different range of columns then go to the GA API (checked in Fiddler). From what I can see, this connector is a native .NET connector, and I'm not sure if a similar result can be achieved with the Power Query connector.

The main problem I have is transferring state between functions connected to specific navigation tables. I would like to save checkboxes that have been checked in some variable, and then build a query on this basis when a new checkbox is selected. At the moment I don't have a solution for this, and I see that other Power Query connectors rather implement such parameterization as function parameters.

I can try to create some Azure Function as a helper function that will save the state for a few minutes based on some randomly generated number in the connector, but it seems a bit strange to me and I would prefer to do it locally in the connector.

Do you have any other ideas how I can implement something like this application state/global variable, or is there any other method to achieve this? Unfortunately, the navigation tables documentation is quite poor... Thanks in advance for your answers.

No RepliesBe the first to reply