A great way to share data between Excel users is to use an Office Data Connection (ODC) file. They are designed to be portable and easy to update. We recommend the following approach …

You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog …

Jul 20, 2018 · I am using Excel 2013. I am creating a connection file with the details and query to an Oracle Database. Click on Data / Connections / Add / Browse for more / New Source / …

Apr 16, 2013 · I need to connect to external data sources from Excel. I have .odc files with the connection information. I want to place these files on a network folder so everybody can use …

Dec 4, 2017 · The .odc file is the connection within Excel only. Power BI Desktop can't import or directly use it. However, you can read the Server Name, Database Name in .odc file. Then …

Oct 13, 2021 · In this article, I will show you how to open an ODC file in Excel, or create one if you need to. What is an ODC (Office Data Connection) File? An ODC file contains the information …

Nov 16, 2012 · My goal: Create an office data connection (ODC) file that uses a OLEDB connection string and SSS ID (Secure Store Service) that connects to a SQL Server database …

Nov 7, 2016 · With Power BI publisher for Excel, you are able to analyze with a pivot table connected to your data in Power BI, and there’s no need to download .odc files, and no need …

Jul 18, 2018 · To deploy an ODC file, you must create the file by using the Data Connection Wizard in Microsoft Excel and then add the ODC file to Enterprise Portal. The following …

Aug 7, 2023 · Another way to load the data from an ODC file into Power BI Desktop is to open the ODC file in Excel and then import the Excel workbook into Power BI Desktop2. This way, you …