Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am creating a custom data connector and am currently working on the navigation table. I am writing this using the sdk in visual studio.
I am attempting to have a function in my navigation table that will take in user inputs to search through a larger table with their specified conditions. While I have found evidence that this is possible https://github.com/Microsoft/DataConnectors/tree/master/samples/TripPin/1-OData and https://github.com/Microsoft/DataConnectors/tree/master/samples/OpenApiSample they both seem to import their naviagtion tables in through metadata returned from their queires which is not an option for me.
Despite my best efforts I am yet to find anywhere that actually shows how to do this. I have tried simply putting a function that requires arguments in my navigation table but with no luck as it gives me an error that it is expecting parameters (which makes sense, but I need the user to enter them). I have even looked through the json metadata returned by some of the queries in the above examples with the closest I could find to anything was a value in the functions section setting IsComposable="true".
Any help or direction to a source which can help me would be greatly appreciated.
Hi, I've founs the example of using functions in Navigation here https://github.com/microsoft/DataConnectors/issues/30
Hi Yuval, have you found the solution?
I see you managed to get some sort of solution to this problem. I wonder if you would be able to provide some pointers in how you solved it.
I am having the same issue for a custom connector i am working on. I have a number of functions that take different parameters and i would like to expose them via the navigation table. I can get it to work if they don't require parameters from the user but i can't work out how to allow them to enter anything. If i mock up something that auto-generates the Navigation table they appear as expected but unfortunately this isn't really an option for what i need to do.
Hello, did you find a solution? I'm struggling with a similar problem.
Cheers.
Hi
I managed to get it close but not perfect, I am back to looking for a way to do this again. I will let you know if I miraculously do make an progress
Hi, i also made a workaround for my case. If you're interested, when you try it again, i can try to help.
Cheers.
CAOP
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
2 |