Questions tagged [external-data-source]
51 questions
0
votes
0 answers
Visio VBA Macro recreate drawing
I have an Excel table linked to a Visio Org Chart using the below steps:
Organization Chart Wizard
Information that's already stored in a file or database
A text, Org Plus (*.txt), or Excel File
Browse for File Location
Name="Employee Name"
Reports…
Minyun
- 35
- 4
0
votes
1 answer
The target principal name is incorrect when querying from Azure SQL DB External Table
I've successfully created a Master Key, Database Scoped Credential, External Data Source, and External Table to reference another AZ SQL Database hosted on the same server, but am unable to query the External Table.
The following code runs…
alwayslearning
- 3
- 2
0
votes
0 answers
Save a pivot table structure based on external source without saving/cacheing the data
I have an external data source that implements row-level security.
I have an XLSX file which I want to distribute which will have a pivot table based on the external source. All of my users have an identically configured ODBC connection, except it…
Adam Cunnington
- 101
- 6
0
votes
0 answers
Sharepoint external data keeps on refreshing
We have a problem with our SharePoint external data. When I try to access the external data in my system it kept on searching, I cannot see any data. But when I tried the same from the server, I can access the data. I checked the log but I am not…
Sabarish
- 1
- 1
0
votes
0 answers
Deploying Azure SQL Server with external data sources
I have two environments, development and production. Each one of them has 2 databases, one main database and another that is used as an external data source.
Currently I'm trying to create a github deployment pipeline, I use SSDT to do source…
Pablo
- 3
- 1
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 to create a view where data resides in a view on remote Azure SQL Server
I'm trying to create a view of data that resides in remote Azure SQL Server. I can't seem to create a table or temp table in the view to store the results of the sp_exeucte_remote call because that is not allowed so I tried to use a function, but…
Geekn
- 2,650
- 5
- 40
- 80
0
votes
0 answers
Amcharts - not able to load external Json data
I'm trying to load external json data into regular amcharts line chart. If I paste exactly same Json data into chart.data property it works perfectly. But when I use chart.dataSource.url property and call the page with same json data, its not…
0
votes
1 answer
Azure - How to execute UDF from external data source in select statement
I have an external data source created in DB1 and its pointing to DB2 database in Azure.
I want to query a UDF defined in DB2 from DB1.
Following syntax works, from DB1:
EXEC sp_execute_remote
N'Ext_DB2',
N'SELECT Result'
But I want to use…
User2019
- 61
- 1
- 6
0
votes
1 answer
Azure DevOps pipeline for SSDT project can not find the variables when it does not need to create object
I am using Azure Devops to deploy my SSDT project. I am trying to update my Azure SQL Data Warehouse where I have DATABASE SCOPED CREDENTIAL and EXTERNAL DATA SOURCE.
I found this article and I did those steps.…
Ardalan Shahgholi
- 11,967
- 21
- 108
- 144
0
votes
1 answer
MediaWiki Graph with data from external source
I used a graph from the Vega example and add it to my MediaWiki page and it works,
I have replaced in the "data": section the "values": part with the
"data": [
{
"name": "table",
"url":…
shalom
- 11
- 2
0
votes
1 answer
How to run counts from text file for different functions
I have a task where I need to run certain functions based on a text file to count certain text. The first set of instructions I was able to do myself as it is not user based and it is just a general count of text items in the text file (tasks.txt).…
NoobDev88
- 23
- 6
0
votes
1 answer
How to correctly replace data in text files based on input
I have the following problem. Im trying to replace the name based on the input of gender. If anyone could help improve my code it would be really appreciated.
The text file(duedate.txt):
User: Tommy
Gender: Male
Date due: 2020-02-18
The code I…
NoobDev88
- 23
- 6
0
votes
2 answers
How to correctly replace line in text from a referenced line
I have written some code to take in users and assign tasks to them using a text file. The problem I am having is as the user inputs a task number to edit, but I don't know how to replace the line of text 12 lines above the task number that is input…
user12916903
0
votes
1 answer
How to use external data plot a multi lineseries chart
I am using amcharts4 plugin to plot a multi-lineseries graph.
But the plotted points do not locate at the right position (Blue dot at the edge of y-axe)
Here is the output chart that I get. (pls see the attached above)
Not sure what had done…
user610983
- 855
- 2
- 9
- 14