Top "Powerquery" questions

Microsoft Power Query for Excel enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more.

Power Query -> Transform Comma to Period and Obtain Decimal Numbers

I'm working within Excel Query Editor (Power Query) and I have a table with many columns. Some of the numbers …

Read More
excel powerquery m
MS Power Query: Create date from month, day, year

How do I create in Power BI Desktop the date from separate columns with data for month, day and year.

Read More
date powerquery
How to wait for a Power Query refresh to finish? I've tried "DoEvents" with "BackgroundQuery = False", and more, nothing works

Setup: Windows 7 (at work) Windows 10 (at home) Excel 2016 (build 4627 at work) Excel 2016 (build 8730 at home) Power Query is setup to …

Read More
excel vba refresh powerquery doevents
How to refer columns in Power Query by index or position?

I have a line as below in Power Query. So instead of referring it by name, I want it by …

Read More
excel powerquery
VBA Wait for refresh of power query to execute next line of code

I am working on a VBA project, that requires update of a specific table via power query as part of …

Read More
excel vba refresh powerquery