Power BI Connector - How to Publish Online?

Molly Mangan

We have the Sky API connector working with desktop Power BI. We would like to publish the dataset to the online PowerBI Service. The model and visuals publish fine, but the data is not refreshable. It receives the error: “Unable to refresh the model (id=nnnn) because it references an unsupported data source.”

Has anyone found a workaround for this? It seems like if we could reference the Client ID, Secret, and subscription in the Blackbaud() source in power query, that it might work. Haven't seen any syntax or sample of this.

Matt Thacker

Hey @Molly Mangan, have you set up the on-prem Data Gateway for the Power BI Service to access the Blackbaud Connector?

Molly Mangan

@Matt Thacker No, I was hoping to do a direct connect given that it is API driven. I'm playing with the API syntax to see if I can set that up without the RE-BI connector in the middle.

Mark Warner

@Matt Thacker Did the Power BI connector disappear? I search for it in the data connectors and can no longer find it. Thank you!