Forum Discussion
Implement TestConnection with both Uri.Type plus optional parameter
Thank you for reaching out to the Microsoft Fabric Forum Community.
Akash_Varuna thank you for your inputs.
f_daniel_souza -I have attached some official documents below for your reference. They may be helpful, so please take a look.
Gateway Support for Power Query connectors - Power Query | Microsoft Learn
Solved: Custom Connectors - API url + body - Microsoft Fabric Community
Custom API Connector - Data Source Path - Microsoft Fabric Community
Thanks.Hi Anonymous , unfortunately I couldn't solve this current problem, however I managed to create a dynamic navigation table that let me to call specific entities APIs with some engineering. You can close this thread nonetheless.
Thanks!
Super UserHi f_daniel_souza To do the TestConnection with Uri.Type and an optional parameter, ensure the DatasourcePath combines the base URL and parameters logically. Structure TestConnection to match the arguments of your DatasourcePath. Use Record.ToTable to include optional parameters effectively. Test thoroughly with both URL types to ensure compatibility.
Hi Akash_Varuna, thank you so much for the reply. Do you have any code example representing this scenario? I have already tried several different things, such as parsing the dataSourcePath with Json.Document, or using static values, some of them actually pass the VSCode TestConnection but fail on Power BI Service. I think I've read all Github examples, but none of them covers a Uri.Type + second parameter, so I assumed Microsoft "special handling" of Uri.Type might be causing the problem.
Thank you for reaching out to the Microsoft Fabric Forum Community.
Akash_Varuna thank you for your inputs.
f_daniel_souza -I have attached some official documents below for your reference. They may be helpful, so please take a look.
Gateway Support for Power Query connectors - Power Query | Microsoft Learn
Solved: Custom Connectors - API url + body - Microsoft Fabric Community
Custom API Connector - Data Source Path - Microsoft Fabric Community
Thanks.I hope the information shared was helpful to you. If your question has been answered, kindly mark the most relevant reply as the Accepted Solution. This small action can make a big difference for others who are looking for the same solution.