
Excel Power Query Anonymous Credentials - social.technet.microsoft.com
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 have the same …
How to split a column in Excel Power Pivot 2013?
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 …
running simple query against MS Access database very slow
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.
DataSource.Error: SharePoint: Request failed: The operation has timed …
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 give Timed …
Power Query custom Windows credentials authentication with Odata …
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 …
Function for Power BI (M query) for Lat and Long
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.
Multiple Queries - Run One After Another
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 next one.