Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
donnarenia
Frequent Visitor

Power BI and Excel and Wolter Kluwer CCH Axcess

I am working with Wolter's Cluwer CCH Axcess API and pulling data to create customized dashboards in Power BI.  I have one report i am working on and I am able to pull a majority of information from my CCH Axcess Gateway and include an excel data file also.  however when I try to pull notes associated with the projects, I keep getting the message that there is no relationship.   I have the following relationships...the ones unchecked are all the ones that break my report.  Does anyone have experience with CCH Wolters Kluwer products or can help me with this issue.

 

Annotation 2019-07-24 083005.png

12 REPLIES 12
silversea
Regular Visitor

Usually what you want to do is pulling data into SQL or some other database (Excel and CSV could be one) then look at the data. Please feel free to schedule a call with me if you still need help on this. I do a lot of development on CCH API and DAU. https://calendly.com/ductrancpa/30m

Westgate83
Frequent Visitor

I'm new to using CCH Axcess Data Axcess Utility....I'm a complete Power BI novice but have muddled through ok. I'm now stuck on how I get my Data Dashboards published so all staff can access the reports. I've tried looking online but nothing seems to be in laymans terms and I don't quite understand. CCH have just left that part out of any training....if someone is able to send me a brief guide, I would be very grateful!

Do you have the data dictionary? that's always a good place to start, so you understand which fields need to be used to join. Please feel free to schedule a call with me if you still need help on this. I do a lot of development on CCH API and DAU. https://calendly.com/ductrancpa/30m

Donnajones
Frequent Visitor

Do you have examples of how you have used Power BI and CCH for reporting

 

Please feel free to schedule a call with me if you still need help on this. I do a lot of development on CCH API and DAU. https://calendly.com/ductrancpa/30m

PentaGalDad
New Member

I see this is an old post, but curious if you ever found any info. I too am trying to use Power BI to display CCH Axcess data. Any resources you recommend? Thx. 

Please feel free to schedule a call with me if you still need help on this. I do a lot of development on CCH API and DAU. https://calendly.com/ductrancpa/30m

Hello, please contact me if you have any need for Power BI report for CCH. I do a lot of development work in this area and I'm happy to help you and your firm.

Hi Silversea,

 

I am trying to implement the use of PowerBI reporting from data from CCH Central. Can you kindly point me in the right direction to get started?

 

I look forward to hearing from you.

 

Jimmy

Sorry I missed your message. If you're refering to CCH Axcess and Workstream and Workflow, I've worked with them. Not so much CCH Central but i'll be happy to take a look.

Don't worry about, I eventually connected the SQL server to Powerbi wth a connector and have been manipulating the data ever since. Thanks for the reply 🙂 

Would you like to connect so we can exchange ideas and what we've done with Power BI to CCH Axcess? May be we'll have a thing or two to learn from each other.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.