Power BI Issues

Bob Rickards

Happy Friday…anyone else having issue with Power BI and getting data back from Blackbaud on refreshed dashboards? We are using a personal gateway, and connecting to Blackbaud Custom Beta connector. All of a sudden I am getting the following errors on several tables.

Data source error:

The '<oii>opportunity_likelihood_name</oii>' column does not exist in the rowset. Table: Opportunity.

Seems I am getting this also on Funds. Any idea why this is all of a sudden happening. I have taken Matt posted…but that did not fix the error. I have also uninstalled and reinstalled my gateway with no success.

Now I can refresh in desktop and publish with no issues…but I can not schedule a refresh, else it fails.

Any ideas would be appreciated.

Bob

Alex Wong

@Bob Rickards
If you can refresh on your own desktop. That means your gateway computers is not the same as your desktop custom connector file. This may be because you upgrade your custom connector when Matt posted his upgrade but you didn't upgrade on the gateway

Copy from your desktop to the gateway computer.

Bob Rickards

@Alex Wong Thanks….that was the issue. Never even thought about that. Appreciate it.