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 …

Anyone knows why the closed file cannot get refreshed as configured or this is the requirement by MS Excel to keep the file open for refreshing data in regular basis (every x minutes)? Any suggestion? …

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.

In Excel 2010, there is no effective way to identify the Office SKU for an add-in like Power Query. Chances are that you were using a non-ProPlus version without Software Assurance, which is not …

Power Query has been updated already and now this message is appearing on all the user's computers. Any ideas as to how I can hide this message using the registry and/or group policy?

Question 0 Sign in to vote Dear All, I want to write the query to get the whole unit column as per below table is calculated whole unit column in Excel

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 …

Does anyone know how to do this with Power Query? If it is not possible with Power Query, maybe it with DAX? Thank you in advance Sincerely, Mike Girvin Wednesday, June 28, 2017 11:28 PM

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.

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 …