Is there a way to add the bdna database as a data source on excel or powerbi?
Dec 03, 2019 01:21 PM
Yes... you can select export results to a csv file which can be loaded into either excel or power bi
Or you can use a sql database connection to import the BDNA_PUBLISH database into PowerBI. There are a number of FACT tables and DIM tables which can be easily loaded into PBI for reporting. There is also a published ERD on the support site which describes BDNA_PUBLISH tables
Dec 04, 2019 03:10 AM
where can I find the server name and database name and account to use to connect to the data source?
Dec 04, 2019 01:44 PM
I do not know who completed your install but someone will have installed the application server you use to access the Data Platform website. This is linked to a SQL Server instance which will be hosting two databases (BDNA and BDNA_PUBLISH). You will need the database admin to grant you read access to the BDNA_PUBLISH database
Dec 05, 2019 06:53 AM
is there a specific port that I need to connect to the db?
Dec 11, 2019 10:09 AM
Port 1433 is typically used... but it is possible for this to have been changed during the installation
Dec 11, 2019 11:05 AM