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.

How to set a max run time / timeout for Power Query?

Is there a way to set a max run time or a timeout factor in Power Query so that after …

excel timeout powerquery m
Select row with MAX value per category Power BI

How to select row with max value per category in M of Power BI. Suppose we have table: +----------+-------+…

powerbi powerquery m
What do "Enable Load" and "Include In Report Refresh" mean/do?

In Power Query, when I right-click on the name of a query (in the left-most pane of Power Query's window) …

powerbi powerquery
SUM IF in Power BI

Is it possible to SUM on conditions in Power BI? I have a column that contains the values UK and …

powerbi dax powerquery
Edit SQL in Power Query

When I import data from Sql Server in Power Query, I can paste a query to be executed against the …

excel-2010 powerquery
PowerQuery: How can I concatenate grouped values?

If I have the following table (shown in the image below), how can I write a grouped query that would …

excel group-by powerquery excel-2016 m
Power Query Transform a Column based on Another Column

I keep thinking this should be easy but the answer is evading me. In Excel Power Query, I would like …

excel powerquery
How to search multiple strings in a string?

I want to check in a powerquery new column if a string like "This is a test string" contains any …

powerbi powerquery
How to change source of a power query using VBA?

So in Excel 2016, they have this neat tool called Power Query, basically a glorified excel table. Every table has steps …

excel vba powerquery
How can I perform COALESCE in power query?

I have a table that has values for quarters and I need to add a new column that gives me …

excel powerquery