Forum Discussion
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.