x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 241 subscribers
  • Views 904 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Kyle Vonck

Estimating reports into Power BI

Posted By

Hello,

I’m new to Sage and looking to access estimates through Power BI.  I’ve connected through ODBC, but I do not see how to get estimate information, only Database information.

any ideas?

  • 0

    You can point Power BI to the Timberline Data Source to connect into Sage 300 CRE data. I believe there is an article about the Timberline Data Source if you search the KB for info on how to get that configured.

    From there I would start with the JCM or PJ tables to begin finding data relevant to estimates.

  • 0 in reply to jstone1

    Thanks for the quick response.  We are currently only using the Sage Estimating product (which includes the Config wizard, DB Editor, Management Console, Means Integrator, and Estimating application).  It's running on top of SQL Server Express and when I try to find the data source in Power BI, I've only been able to login via ODBC.  From there I have access to the server, but have been unable to locate any Estimate data.  Only structural data like Items, Assemblies, Header Estimate info, etc...

    Does that make sense?

  • 0 in reply to Kyle Vonck

    Did you ever find a solution? 

*Community Hub is the new name for Sage City