Unable to use Power Query to Connect to a Sharepoint List
I'm trying to import a SharePoint list in via PowerQuery. When I try to use the root folder (and any variation there of) with my windows credentials I get an error: 400, Bad Request. I've tried using my Organizational account (like when you login the first time and use your email) it says "we are unable to connect because this creditial type isn't supported for this resource. Please choose another credential type." I'm at a loss as to what to do next... Excel, Power BI, Get & Transform, Power Query SharePoint Lists
How can you use VBA to clear Global Permissions in Power Query
How can you use VBA to reset Data source settings Under Menu Data > Get Data > Data Source Settings where my worksheet has a Data source under the radio button 'Global Permissions' ? by Clicking the "Clear Permissions" button and selecting "Clear All permissions" this will clear out all power query URL references. But, how can this be done in VBA ? with VBA I can clear data sources that are 'in current workbook' (using code below) but this will not work with the "Global Permissions". Sub RemoveConnections() For i = 1 To ActiveWorkbook.Connections.Count If ActiveWorkbook.Connections.Count = 0 Then Exit Sub ActiveWorkbook.Connections.Item(i).Delete i = i - 1 Next i End Sub
NEW POWER QUERY - VLOOKUP WON'T LOOKUP
Here is what I have... I am using Excel as Event Administration software for Auto Racing events. I have a main administration worksheet that pulls entrant data from a table via VLOOKUP function on an adjacent worksheet... In addition, the Timing & Scoring software outputs a .txt file of the results in a tabbed, delimited file format...In prior excel versions, I was able to import this data into a specific cell, overwrite the cells on the Administration worksheet and use cell references to shoot the Car Numbers (field one on the Entrant Data VLOOKUP table) to automatically create the lineups on an additional worksheet using the same VLOOKUP table based on my formatting. Since they have updated the POWER QUERY, I have struggled to achieve success with this function. First, when importing, the data added columns and screwed up the formulae. I have since figured out how to overwrite as before. However, now, the VLOOKUP function doesn't seem to want to recognize integers. It will correctly identify drivers with car numbers that have letters intermingled (to delineate duplicate car numbers - i.e. if John Doe shows up first and he's #4, then he's #4...Jane Doe shows up second and is also #4, she becomes #4X). The only work-around that I have found is to go to the data and overtype the integers with the same integer and everything works fine as before. What do I need to tell my imported data to do to re-create what it used to do on prior versions?