From today's Power BI User Group, I saw @Rebecca Sundquist using Power Query's M code of get local time to get a table of last refreshed date/time for the Power BI. I remember there was reason why I didn't do that, and can't remember. Now, I remember, so I want to put this out here so others can be aware, as well as for…
Hi, I am working to migrate the reports from Raiser's Edge NXT to Power BI. In the process, I am utilizing Microsoft's custom connector to get most of the generic data from RE, and a couple of manual files to get the data that's missing from the connector. I am keen to dashboard how an opportunity is moving in the…
Hello all, I am setting up to get our user licensing in order so I can have access to the connectors I need to make our membership card dynamic and available for our members once we migrate off of Luminate Online. I am reaching out to the Developers out there at other orgs, have any of you done this and could you share any…
Hello everyone, We just got our premium license set-up by IT for power automate!! I was able to successfully create the connection to PowerBI from RE NXT using the Blackbaud/Powerbi-Connector template on GitHub. However, when I go to get data from PBI desktop it won't let me login to RE NXT but instead gives me the…
Hi - we've been asking Blackbaud support (on both partnerprogram@blackbaud.com and skyapi@blackbaud.com) to address a few issues for us in our sandbox access since March and are still awaiting a response. Could Blackbaud support respond please, or if anyone else knows how to get around these limitations, your advice would…
I am using the my Emma API to call a list of our subscribed email members. There are about 20,000 records. Emma returns 500 per page so I am trying to set up a loop to pull the records, parse them, append to an array, and then use that array to compare to RE NXT records to see if anyone that we have marked unsubscribed has…
I used to be able to construct a url that looked like this: https://someserver/WritingPage?envId=p-vnVAbDtfu0GyMqSDmG-_qw&svcid=renxt&context_docId=67ed7b0daee7ffd1bc9db0d7&context_recordId=200 it would take the docId and recordId and add them to the context so that my component can grab them. That worked. Until it didnt.…
Hi All, I'm looking for assistance with a data workflow setup. My goal is to get a specific report from Raiser's Edge exported automatically on a daily basis to a SharePoint folder. I've successfully set up the downstream components: I'm using the Blackbaud Community Power BI template and have configured Power BI to pull…
Hi everyone, I work with a nonprofit organization and we’re looking to implement course Power BI for data analysis and reporting. We don’t have much experience with the tool yet, so I’m on the lookout for training that’s specifically helpful for nonprofits. Are there any Power BI courses that are tailored to the needs of…
We have a Power BI report that runs on a scheduled refresh with Blackbaud connector daily. It's worked without issue until last week, the refresh failed with the error that said “Column 'constituent_lookup_id' in Table 'Constituent (all)' contains blank values and this is not allowed for columns on the one side of a…
It looks like you're new here. Sign in or register to get started.