[DOCS-13858] Error Setting up Microsoft Power BI with ODBC Connection using BI Connector Created: 01/Sep/20  Updated: 01/Sep/20  Resolved: 01/Sep/20

Status: Closed
Project: Documentation
Component/s: BI Connector
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Bhaskar Avisha Assignee: Steve Renaker (Inactive)
Resolution: Won't Do Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 3 years, 23 weeks, 1 day ago
Story Points: 1.5

 Description   

Description

Bryan was able to connect to the BI Connector with Power BI using an ODBC connection, but without the authentication plugin. This connection was using the standard SSL method we describe in the current docs.

Acceptance Criteria:

  • Document how to connect to Power BI using SSL on an ODBC connection to at least get users started.
  • Briefly investigate why the authentication plugin doesn't work with Power BI. This may have been related to DOCS-10075, if so possibly revisit and sync up with Craig Wilson and ask why the authentication plugin doesn't work with Power BI.

Scope of changes

Impact to Other Docs

MVP (Work and Date)

Resources (Scope or Design Docs, Invision, etc.)



 Comments   
Comment by Steve Renaker (Inactive) [ 01/Sep/20 ]

Hi developer.avisha@gmail.com, thanks for filing this ticket. I'll add the Power BI with SSL issue to the list of upcoming improvements for the BI Connector docs. In the meantime, please contact your enterprise support representative for help with the immediate issue. 

Best regards,

  • Steve
Comment by Bhaskar Avisha [ 01/Sep/20 ]

Hello MongoDB, 

I was trying to copy the details of the old story instead i ended up cloning the ticket. here is the problem i am facing, trying to setup Power BI ODBC connection to MongoDB replicaSet using BI Connector

1) This is a 3 node replicaSet with 1 - primary 1- Secondary and 1 arbiter, i have installed mongosqld on primary & secondary instances,  below is the mongodb uri i am using in the config file when i am starting mongosqld as a background process 

Questions i have : 

1) MongoDB BI ODBC connector does not show the option of providing replicaSet Name, how can we setup the ODBC connection to replica set

2) I have setup a user on the both primary and secondary with "readWriteAnyDatabase" permission and i am still seeing in the log "  2020-08-31T21:35:38.074-0400 W SCHEMA [manager] error initializing schema: error listing databases: error listing databases: (Unauthorized) command listDatabases requires authentication"

can you please take a look at below details and share you comments  

config file :

systemLog:
logAppend: true
path: "/mongodb/localdb/mongosqld.log"
verbosity: 2

mongodb:
net:

uri: "LOCAL_DB1:27017,LOCAL_DB2:27017/?replicaSet=TestApp&readPreference=primary"
net:
bindIp: 0.0.0.0
port: 3307

Log file :

2020-08-31T21:35:33.064-0400 I CONTROL [initandlisten] mongosqld starting: version=v2.14.0 pid=3343 host=lxmdbiptpprdw01
2020-08-31T21:35:33.064-0400 I CONTROL [initandlisten] git version: 6fa82d07a176aeee28f685c3f8e8806832c769b0
2020-08-31T21:35:33.064-0400 I CONTROL [initandlisten] OpenSSL version OpenSSL 1.0.1e-fips 11 Feb 2013 (built with OpenSSL 1.0.1e 11 Feb 2013)
2020-08-31T21:35:33.064-0400 I CONTROL [initandlisten] options: {config: "/mongodb/etc/mongosqld.conf", systemLog:

{logAppend: true, path: "/mongodb/localdb/mongosqld.log", verbosity: 2}

, net: {bindIp: [0.0.0.0]}, mongodb: {net: {uri: "LOCAL_DB1:27017,LOCAL_DB2:27017/?replicaSet=TestApp&readPreference=primary", auth: {source: "admin"}}}}
2020-08-31T21:35:33.064-0400 I CONTROL [initandlisten] ** WARNING: Access control is not enabled for mongosqld.
2020-08-31T21:35:33.064-0400 I CONTROL [initandlisten]
2020-08-31T21:35:33.070-0400 I NETWORK [initandlisten] waiting for connections at 0.0.0.0:3307
2020-08-31T21:35:33.070-0400 I NETWORK [initandlisten] waiting for connections at /tmp/mysql.sock
2020-08-31T21:35:33.070-0400 I SCHEMA [manager] attempting to initialize schema
2020-08-31T21:35:33.070-0400 I SCHEMA [manager] sampling schema
2020-08-31T21:35:33.072-0400 I SCHEMA [sampler] sampling MongoDB for schema...
2020-08-31T21:35:33.072-0400 D SCHEMA [sampler] wildcard database selector used: running listDatabases
2020-08-31T21:35:33.073-0400 W SCHEMA [manager] error initializing schema: error listing databases: error listing databases: (Unauthorized) command listDatabases requires authentication
2020-08-31T21:35:38.073-0400 I SCHEMA [manager] attempting to initialize schema
2020-08-31T21:35:38.073-0400 I SCHEMA [manager] sampling schema
2020-08-31T21:35:38.073-0400 I SCHEMA [sampler] sampling MongoDB for schema...
2020-08-31T21:35:38.073-0400 D SCHEMA [sampler] wildcard database selector used: running listDatabases
2020-08-31T21:35:38.074-0400 W SCHEMA [manager] error initializing schema: error listing databases: error listing databases: (Unauthorized) command listDatabases requires authentication
2020-08-31T21:35:43.074-0400 I SCHEMA [manager] attempting to i

Generated at Thu Feb 08 08:08:54 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.