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 also provides you with the ability to search for public data from sources such as Wikipedia.
Questions tagged [powerquery]
5627 questions
4
votes
0 answers
Unable to send a POST Request using Power Query in Power BI Service
I need to send a POST request to generate an access token in Power Query. In Power BI Desktop, a POST request is sent, and it works as expected. However, when I try to refresh after publishing the report to Power BI Service, a GET request is sent…
Kaveesha Silva
- 111
- 1
- 5
4
votes
2 answers
Replacing values based on condition in Power Query
I want to replace some acquaintance values by keywords to specific value, converting both "google" and "searching google" to "seo"
I tried replace but you should specify all the values to replace with and that's not possible.
if there is a solution…
Parsa Omidvar
- 81
- 6
4
votes
3 answers
M Code(Power Query) to Remove Empty columns that runs fast
I use the below code in Power Query to remove empty columns from a table with a lot of columns. It runs very slow and I am looking for a way to speed it up. Basically if all the entries in a given column is null, the column should be…
Rafadan
- 97
- 6
4
votes
2 answers
Pause VBA until #GETTING DATA Power Pivot is complete
I have an Excel workbook with a large Data Model connected to two slicers. I need to cycle through every entry in the slicer, allow the workbook to catch up on loading a large number of cube formulas, then copy one particular worksheet over into…
OldKingCole
- 115
- 12
4
votes
0 answers
MariaDB connector SQL in PowerQuery
I have been using the ODBC connector in PowerQuery to pull data from MariaDB using custom SQL:
Source = Odbc.Query("dsn=jobdb", "SELECT ... From ... WHERE ...")
A dedicated connector for MariaDB is now available and I can access data by:
Source =…
MortenM
- 119
- 1
- 6
4
votes
2 answers
Power Query filter date from today minus ? days to today
I'm just learning Power Query and trying to figure out how modify a filter to return data within a dynamic date range. E.g. from Today - 60 days to Today
Here's the code, any help much appreciated.
= Table.SelectRows(#"Changed Type", each [Start] >=…
Kholt69
- 43
- 1
- 1
- 4
4
votes
1 answer
Refresh report that uses custom functions on Power BI Service?
I am trying to figure out a workaround for refreshing dataset with Custom functions over Power BI service. My query looks like the following:
Data source for _op_kiekis
let
Source = Loginai_File,
#"Invoked Custom Function" =…
Dmitrij Holkin
- 1,995
- 3
- 39
- 86
4
votes
3 answers
disable 'Enable load' in Power Query
What is an example of practical scenario when we might need to disable 'Enable load' of the table in Power Query editor? Does it work the same as deleting the table from the entire data model? If so, why keeping a weed?
Przemyslaw Remin
- 6,276
- 25
- 113
- 191
4
votes
1 answer
How to extract Month and Year from column in PowerBI powerquery
I have a column (monthyear) in the image below. I want to extract the Month and year from the column to put it in the new column. Note: In my dataset this information goes for every day of the year
So the new column would look…
lydol
- 111
- 1
- 3
- 11
4
votes
1 answer
Dynamicaly change chart from category to subcategory
I have a hierarchical matrix with a corresponding chart from this table:
let
t0 = Table.FromRows(
{
{"2020-01-01", "1", "10", 10},
{"2020-01-02", "1", "10", 3},
{"2020-01-01", "1", "11", 8},
…
Clodoaldo Neto
- 118,695
- 26
- 233
- 260
4
votes
1 answer
Power Query Advanced Editor (Json.Document(Binary.Decompress(Binary.FromText)
I have seen older posts on here and other forums with the similar code to the one below and cannot figure out where a portion of it comes from.
let
Source =…
slauer12
- 45
- 1
- 1
- 7
4
votes
3 answers
Apply timezone by id on Power BI
(Here's quite the same question I opened on Microsoft Power BI community forum)
I have a table in my database where I have a column with datetime values in UTC and another column with the timezone of this datetime (a string containing the IANA id of…
Leo von Barbarosa
- 727
- 8
- 22
4
votes
2 answers
How to save a Power Query table as a regular table (without connections) in a new workbook?
I'm looking for a simple solution to exporting a single worksheet containing one loaded Power Query table to a new workbook without the underlying connections and queries.
I think Microsoft changed something in Excel 2019 regarding the behaviour of…
Dariusz Kuśnierek
- 83
- 2
- 7
4
votes
1 answer
Power Query not able to add columns when refreshing CSV import
If a line is added to a csv file, and that line has more "columns" than the original, Power Query won't add columns for the new line when refreshing an existing query.
If a new query is generated, then the extra column will appear. I'm guessing this…
Ron Rosenfeld
- 53,870
- 7
- 28
- 60
4
votes
1 answer
Power Query Applying a Function Across Every Column
I am trying to write a query that takes a table and multiplies every number in the table by 100. I've gotten close, but I am having trouble applying it correctly to every column. Below is the code I have so far. The line starting with…
Zoopzoop
- 43
- 4