Hi all I have an excel file with a power query linking to a share point. When I set up the query I used the New Query option and have no issues. When I share this with my colleagues who …

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 …

I set up some queries in Excel using power query, really very new to it, and trying to see how it can add benefit to my processes, as well as to potentially provide some end user reporting.

I am trying to get SharePoint list data from SharePoint site using Power Query in Excel but while I am inserting URL of my SharePoint site but Instead of asking for the Authentication it directly …

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 …

I'm trying to convert a python script to be a Function for Power BI (Power Query M) the code below takes a list of coordinates (Lat, Long) and returns a central point for the list.

I have a Power Query solution that uses three separate queries (A, B and C) to get to a solution. Currently I manually run A, then B, then C, waiting for each one to finish before starting the …

Anyone have any ideas on this? I have Excel 2016 and when I use the Get & Transform New Query to our SQL server, if I put in the database I want to connect to, I get:

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. …

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