You could check either here: "Data | Queries & Connections" Or here: It's hard from the distance to give a good advise how to deal with it. Best would be to ask the creator if that connection is still needed or if it was a one-time-import.
3. Queries and Connections Pane By using the Queries & Connections pane, you can: Delete a query Rename a query Duplicate a query Drag and drop a query into a folder, or change its order To open it, go to Data > Queries & Connections. This feature is already supported for Windows user...
dataConnections 表示工作簿中的所有数据连接。 externalCodeServiceTimeout 指定为依赖于外部代码服务的公式分配的最大时间长度(以秒为单位)。 有效范围为 1 到 86400(含)。 functions 表示可用于计算的工作表函数的集合。 isDirty 指定自上次保存工作簿以来是否进行了更改。 如果要关闭修改的工作簿而不保存它或系统...
To see theGet & Transform DataandQueries & Connectionsgroups, select theDatatab. ChooseGet Datato select your data source. You can import data from multiple sources, including comma-separated values (CSV) files. Every import creates a query. ...
[Get & Transform DataandQueries & Connectionsグループを表示するには、[データ] タブを選択します。 [データの取得] を選択して、データ ソースを選択します。 コンマ区切り値 (CSV) ファイルなど、複数のソースからデータをインポート...
If you close the 'Queries & Connections' pane, you can reopen it using the 'Queries & Connections' item on the Data ribbon. Selecting the EDIT option opens the dialog box shown in Fig. 1f. With this dialog you can modify the query, change the query name, and use the 'Advanced Editor...
Data providers handle queries, parsing connection strings, and other connection-specific logic. This functionality is not part of Excel Services. Excel Services cannot control how data providers behave. Any data provider that is used by Excel Services must be explicitly trusted by Excel Services. For...
Power Query is a technology embedded in Excel and other Microsoft products designed to help you shape your data. In Excel, select theDatatab on the ribbon to see theGet & Transform DataandQueries & Connectionsgroups. After you import and refresh data from a wide variety of data sources, you...
SelectInsert Table. You now have a table connected directly to your Power BI semantic model. Just like with other Connected Table experiences, the workbook contains a connection that you can review and modify in the Queries and Connections properties. ...
Workbook authors can use existing connections without having to create queries and connection strings. If the data connection details for a data source change, an administrator only need update one ODC file. With that change, all workbooks that refer to the ODC file will use the updat...