search

blackbaud / powerbi-connector

Blackbaud data connectors for Power Query and Power BI
MIT License
22 stars 13 forks source link

Unable to determine the data source due to unknown functions. #11

Closed K37V1N closed 2 years ago

K37V1N commented 2 years ago

I'm trying to setup the dataset in PowerBi Service for scheduled refresh using the personal gateway. When I go to the dataset settings, I get the following error message: "Unable to determine the data source due to unknown functions. When custom connectors are used, the error can happen if gateway doesn't have the extension enabled. Details: Query contains unknown function name: Blackbaud.Contents. Data source for Query1"

and below that is a hyperlink for "Discover Data Sources" but it doesn't seem to fix anything.

In my Personal Gateway settings I have signed in, and under "Connectors" I see the Blackbaud connector loaded.

What could the problem be?

K37V1N commented 2 years ago

I figured it out a couple of hours ago. The settings that I had to change were the "Data Source Credentials" in the settings of the Dataset that I published, inside the PowerBi Online Service. It's entirely possible that this page isn't accessible until you have a standard gateway Also installed, but it's not actually using the standard gateway.... very weird but it works.