I have a client that wants to create a dashboard using Power BI, but not with Sage Intelligence. Has anyone created an ODBC connection for use with Power BI? If so, can you outline what you did?
Thanks,
I have a client that wants to create a dashboard using Power BI, but not with Sage Intelligence. Has anyone created an ODBC connection for use with Power BI? If so, can you outline what you did?
Thanks,
Try these instructions if you want to create a separate ODBC- https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=36933&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=18003&cmd=displayKC&dialogID=712053&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true
The issue i had is that power bi prompted for password and id with every table so i had to save the company, login, and password to the odbc
*Community Hub is the new name for Sage City