[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 |
DescriptionBryan 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:
Scope of changesImpact to Other DocsMVP (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,
|
| 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: mongodb: uri: "LOCAL_DB1:27017,LOCAL_DB2:27017/?replicaSet=TestApp&readPreference=primary" Log file : 2020-08-31T21:35:33.064-0400 I CONTROL [initandlisten] mongosqld starting: version=v2.14.0 pid=3343 host=lxmdbiptpprdw01 , net: {bindIp: [0.0.0.0]}, mongodb: {net: {uri: "LOCAL_DB1:27017,LOCAL_DB2:27017/?replicaSet=TestApp&readPreference=primary", auth: {source: "admin"}}}} |