Power BI API connector to pull RENXT Query to Power BI

Dongjay Lee

Hello!

Is there a way that I can load the Query in Webview to Power BI by using API connector in SKY API? Currently I can load the data of lists in Webview, but I could not see ways to load the queries that I built in Web view.

Alex Wong

@Dongjay Lee
Power BI (unofficial) Blackbaud connector only does some of the list API endpoint (i.e. constituent list, constituent custom field list, gift list, fund list, etc). This is not to be confused with “webview list”.

Query API is not supported by the Power BI (unofficial) Blackbaud connector at this time, nor do I think it can be supported, as it requires multiple calls to get the data, and every query can be different data point (i.e. issue query to be executed, check if query done execution, recheck if not done, then download the data as CSV, JSON, or JSONL).

If you want to use Query API in Power BI, you can check out my template for doing that:

https://community.blackbaud.com/forums/viewtopic/586/70826