external connections

Hi guys, My file pops up an error msg every time I refresh it says can't find the external file used, but actually, I don't have any formula or table linking to that file -- I have checked: 1. and 2. None of these involves the file the error msg mentioned. I do find the file in Existing...

I'm using Excel Professional Plus 2016 to connect to an external SQL Server connection. First, I pull the data into the Excel sheet and now see the data that exists based on my query criteria. [Shown as columns A,B,C] After that, I'm adding new manual columns that do not exist in the external...

I set up external connections to excel workbooks to load data into power query (went fine). I decide to test the refresh feature by changing some things in the source data. It won't refresh -ever. Any idea what he problem is. What's the point of having a refresh feature if the connection...

I am able to generate an "Item Master Report" from my company's Oracle portal that shows all the available information about all of our products. At this point, the file is roughly 18,300 Rows and 131 Columns. I used a Power Query to delete irrelevant columns to cut the file down to 5.70 MB...

Hello there, My company uses a SQL server to store large amounts of data and I've built several dashboards that use pivot tables linked to the database. Lately on a few of my files I encounter this error and then if I select "Yes" then all or some of my pivot tables are removed and revert to...