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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
New Member

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors