Connecting to SharePoint List or SP via OData Feed Archived Forums > Power Query Whenever I try to connect to our on premises SP server I get the following error:

Unable to connect We Encountered an error while trying to connect Details: "Microsoft SQL Line 1: Incorrect syntax near 'max'" If I exclude the database name and just ...

I am currently trying to find a way for a customer to connect with Power Query to access their published Odata-feed (which is hosted by Microsoft NAV 2013 R2). For security reasons the NAV server is set …

It's pretty awesome how you can define Extract Transform and Load processes within Power Query without having to type in a single line of code. However how do I reference a Power Pivot table from …

I have a column where it contains same names with spaces in it. I want to replace with it by removing spaces in it. For Eg: MrRichard - Mr Richard, MRPeter - Mr Peter Awaiting for your response Kind …

I need to extract a table with selecting columns in power query dynamically.

The change is in the Text.Combine function. Instead of simply using only characters in the range {"A".."z"}, we look at all characters in the extended ANSI character set except for digits 0 to 9. One …

I looked at all the buttons on power query but nothing to make them into 2 columns I have looked everywhere and, I don't know how to do this : ( any tips Cheers Dan Friday, July 22, 2016 1:00 AM

I have a bunch of text files with columnar format but with 90% same data but there are differences. I have done a bunch of steps on them applying dynamic transformations when appropriate because …

For example, a Name column as LastName, FirstName can be split into two columns based on the comma (,) character. By Number of Characters parses a text value based on a character position …