User Profile
Judit950
Copper Contributor
Joined May 26, 2022
User Widgets
Recent Discussions
Power Query & ODBC
Hi Everyone, I hope you are all well! 🙂 I am new to Power Query and I have been trying to load data from an Excel workbook with several tabs / calculations into Power Query via the Data ribbon > Get Data > From File > From Excel Workbook. I then select the excel sheets I wish to transform. After transforming the data, I find launching the Power Query editor is very slow. A such, I wanted to try to use ODBC instead to see if this would be any faster. However, upon selecting the workbook for import under Data ribbon > Get Data > From Other Sources > From ODBC (and selecting the Data Source Name), only tables (in my case the named ranges I created in the source file) were visible for selection and further transformation. The excel worksheets themselves were not visible. As such, can someone tell me 1) Is it possible to connect to excel binary files effectively 2) Is it not possible to transform Excel worksheets in ODBC? 3) If not, how can I make the first method I described above any faster? Many thanks for your help in advance, very much appreciated! JudithSolved1.8KViews0likes3Comments
Recent Blog Articles
No content to show