Missing tables/fields while connecting to PowerBI using custom connector

Akhil Eldho Renji · July 10

I have connected my RENXT tables to PowerBI through SKY API using a custom powerbi connector. However, it doesn't have all the tables/fields as expected. For example, the entire "Constituency" table is missing while pulling data from RENXT. Is it possible to add the missing tables/fields to the existing connection?

Alex Wong · July 13

not sure what you mean by "Constituency" table is missing.

the power bi connector does pull the Constituent codes table for constituent. If you are in the "Power Query" Preview screen, you won't see them all yet. After you load into Power BI screen, then you can see them all.

Akhil Eldho Renji · July 13

@Alex Wong Thank you for your response. I was able to find it as a table named as Constituent Code Types from the power query itself. I was looking for the field as shown in the attached image 1.png (RE Dashboard view) and the respective table from the power query of the connector is as shown in the attached image 2.png.

2.png

1.png

I do have a follow up question. Any idea on how to find the following fields from the connector? I couldn't find any relatable names for these from the power query:

First Gift Campaign Category
First Gift Date
Total Amount of Gifts
Gift Total Number of Gifts
Ethnicity

Alex Wong · July 13

custom connector of power bi is issuing constituent list, gift list, etc, which obeys the returned data from their respective API endpoint. they do not returned data like like Query.

The fields you want is going to have to come from Query API, which the custom connector for Power BI does not support currently. You can use this potentially:

Sharing my Power Automate and Power BI template: Power BI use of Query API via Power Automate — Blackbaud Community

Akhil Eldho Renji · July 15

Thank you so much. Will go through and see if we are able to fix the issue.

Akhil Eldho Renji · July 21

@Alex Wong For some reason, the files are not downloading from the folder BBQueryAPIDataForPowerBI_20260612024823.zip. Attaching screenshots for your reference

Screenshot 2026-07-21 125340.png

Screenshot 2026-07-21 125309.png

Tried from my colleague's system as well.

Erik Leaver · July 21

@Akhil Eldho Renji Please note that on the original file/template. We'll need to tag in the community manger to help troubleshoot your download issue.

Akhil Eldho Renji · July 21

@Erik Leaver I am getting a Permission Problem when I tried to tag in the link:

https://community.blackbaud.com/discussion/71846/sharing-my-power-automate-and-power-bi-template-power-bi-use-of-query-api-via-power-automate

. Please find the attached Screenshot for your reference

Screenshot 2026-07-21 133200.png

Missing tables/fields while connecting to PowerBI using custom connector

Best Answer

Answers

Categories