Questions tagged [data-connections]
116 questions
0
votes
1 answer
Connect to Oracle Database from MS Excel or Power BI
Trying to access tables from Oracle using MS Excel 2019, yet every time I tried to access the oracle from the Data ribbon /Get Data, a pop message got displayed stating:
``
The recommended provider ('Oracle.DataAccess.Client') is not…
Tarabztk
- 1
0
votes
0 answers
Tableau Published Data Source not appearing on 'On This Site'
I have a live connection to a database. I can see the data in Tableau so I save that as a published data source. When I return later on to select data sources to connect to for my workbook, it does not appear on 'On This Site'. It does when I first…
0
votes
0 answers
I am getting error on my postman application Error: connect ECONNREFUSED 127.0.0.1:3000
app.js file code I am trying to connect mongodb
const express = require('express');
const dotenv = require('dotenve');
const bodyParser = require('body-parser');
const app = express();
app.use(bodyParser.json());
const connectDB =…
0
votes
0 answers
Sync two excel workbooks
I'm having a problem with syncing data between 2 excel workbooks. I found a lot of solutions on Internet that using data connect in excel. With data connect, I can connect Workbook1(main workbook) to Workbook2(sub workbook). If data in Workbook1 is…
Duong Sansen
- 1
- 10
0
votes
0 answers
Error "DUPLICATE_DECLARATIVE_COLUMN_INFO" while connecting Quicksight to AWS Catalog via Athena
I am trying to connect Quicksight to AWS Catalog via Athena and upon selecting the database and the required table, i am getting an error saying "DUPLICATE_DECLARATIVE_COLUMN_INFO" though there is no duplicate columns.
I am able to connect to it…
BI_Dev
- 11
- 2
0
votes
1 answer
Updating data connection adds values but moves previous data in Excel
So, I have a table that gets updated data from Smatsheet, this information is then used in a macro that flags each row that has been processed so the next time these rows won't go trough the same process. The problem is that every time I update the…
TonyMadMax
- 45
- 1
- 5
0
votes
1 answer
How to make a new OLEDB data connection in Excel 365
Looks like a silly question, but Excel 365 defaults to creating a new query type connection when you want to "get data". We are used to creating OLEDB connections to Oracle, SQL server and MS Access databases at work and in previous version of…
Maarten Deen
- 73
- 7
0
votes
1 answer
Can't read database name web project
Trying to read the database name but it's not working in the site. Using an asp.net web project with a solution file. I put this in the web.config. This will change depending on development database or production database PRODDB via the web…
PaulR
- 23
- 1
- 7
0
votes
1 answer
Unable to connect Power BI to Azure SQL DB
I am using a service account (AD account sync’d with Azure AD) to connect to Azure SQL DB (Note: SQL account connection works but need AD account to work)
Service account (abc@xyz.com) has ‘Read/Write’ access on Azure SQL DB
Service account…
shazufaraz
- 59
- 8
0
votes
0 answers
How to handle connections with a Winform C# & SQL Server in the cloud connection issues
I have a Winforms application that uses SQL Server in the cloud. Have Dapper handling the data side. I wrapped all my data calls in a try/catch and bubble them up. However, they are sync methods and was thinking about moving to async but the user…
Zippy
- 455
- 1
- 11
- 25
0
votes
1 answer
How do I 'trust' an external data source in Excel?
I have a tool that uses an external data connection to keep a dashboard updated from single CSV which contains a data log. I don't want anyone touching the log itself and fiddling with it, so I have put together a small dashboard that is fed from…
ValhallaCupcake
- 1
- 2
0
votes
1 answer
how can I control the order in which Excel data connections are executed?
I'm setting up an automized job that loops through a stack of SQL Data each time the data connections of the Excel Worksheet are updated and saves the Worksheet under a dynamically set name. I have 3 data connections that all point to SQL Stored…
Barnabeck
- 459
- 1
- 6
- 26
0
votes
1 answer
Python data connection OLAP/Cube
I would like to connect the OLAP Cube through python.
(First)Basically I would like to import data from OLAP Cube.
(Second)And import columns through DAX is there any way to run DAX formula in Python.
I'm ok if python doesn't have any option for…
mbl
- 1
0
votes
1 answer
Kafka connector for ArangoDB
Can we use Apache Kafka to connect to ArangoDB? I can see the support for DirectMQ for ArangoDB but if I want to use Kafka to get data from various sources and store it on ArangoDB
Chinmay
- 1
0
votes
2 answers
how to use the data in the database in Web Services in C#
i am a newbiest of c#, i need to write a webs service in C#. However i meet some problem
how to connect the database that i create in the visualstudio ( i click on the server explorer tab, right click on the data connection and click on create new…
CutexBabies
- 103
- 1
- 4
- 10