Stack Overflow
Stack Overflow

Questions tagged [powerquery]

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.

5627 questions
1
vote
2 answers

Generate all Possible Unique Combinations of two Excel Columns

I have the following simplified data set which I need to create a unique list from and transpose the data from column B at the same time. I think I need to use INDEX, but I am unsure on the correct syntax for this scenario. The data in column B is…
user3580480
  • 442
  • 7
  • 14
  • 45
1
vote
1 answer

Excel Power Query connection to another table

Fairly new to power queries and finding my feet largely by trial and error. I have build a master query returning ~ 2000 rows of data covering different regions. I want to create sub reports on different tabs for each region. I can easily do this…
user11345588
  • 69
  • 1
  • 2
  • 8
1
vote
0 answers

Export Excel PowerPivot recordset as offline cube

I have a PowerPivot model that has Power Query as a source. Is it possible to create an offline cube from this? I've tried creating a pivot table out of the PP and then using the pivotttable.createcubefile method, but get an error: A cube file…
Sergei Trunov
  • 165
  • 9
1
vote
1 answer

What should be the return type of my Power BI function if I want to use it as axis value for my report

I want to write a function which accepts a date parameter and creates hourly date and time data for that day (i.e for 24 hours). I want to use these 24 hours as axis value for my Power BI report. In what format should these values be returned so…
Deltapimol
  • 146
  • 3
  • 14
1
vote
2 answers

Power Query: pass column name as function parameter

I'm struggling to pass column names to a power query function - if I pass them as [columnname] within the function call, it tries to implement them outside the function; if I pass using [parameter] within the function itself, it looks for a column…
Daniel
  • 15
  • 1
  • 3
1
vote
2 answers

How to import data from MS-Access to excel power query using sql statement and vba?

In the company that I work, there is a folder with many access database files that are generated by a system. They have all the same structure but different data. I'm trying to build an Excel tool to compare and analyze some of them using power…
Cristiane Salgado
  • 93
  • 1
  • 8
1
vote
2 answers

Powerquery to split delimited columns into unique rows

I have a spreadsheet that looks like this: I would like it to look like this at the end: I know that I can use PowerQuery to delimit and expand into rows, but that would only work on the first column. The second time doing that would introduce…
otictac1
  • 155
  • 1
  • 11
1
vote
1 answer

Insert current date in column name

I'm starting to use Power Query in Excel 365 (desktop install). Is there a way to change the column name to append or prepend today's date to the column name? If the column is named "Size" I'd like the column to be named "Size_2019_04_18". The…
Jason
  • 21
  • 3
1
vote
2 answers

Conditional averages (AVERAGEIF) in PowerQuery (M)

I have this table: Month Group Value 1 A 100 2 A 115 3 A 125 1 B 200 2 B 215 3 B 225 I am trying to create a new (fourth) column which…
Andreas
  • 129
  • 2
  • 8
1
vote
1 answer

Is there a way to dynamically switch which relationship is active in powerpivot (based on slicer selection)?

I have a fact table (MORT) and a dimension table (GEO) in PowerPivot (2016). There are two joins between the tables with two columns in MORT relating to one column in GEO. We can call one join RES and the other REG. I have a large number of measures…
will1329
  • 173
  • 2
  • 14
1
vote
1 answer

Find the default table name after rename

I have a file in PowerBI that contains some tables all linked to SQL SERVER. My problem is this: To make user use easier I renamed the tables to a friendlier name, but now I need to know the actual name of the table in the database and I can not…
Clayton Tosatti
  • 196
  • 1
  • 4
  • 20
1
vote
2 answers

How to get current month in power bi

I'm trying to add a custom column in power bi by this query: = Table.AddColumn(#"Filtered Rows", "IsCurrentMonth", if(Date.Month([Timestamp])=Date.Month(NOW())) then "Current Month" else "Other") but the result is: Expression.Error: The name 'NOW'…
TheGeeky
  • 962
  • 1
  • 12
  • 34
1
vote
0 answers

How to restructure Power Query script to support sceduled refresh of multiple csv files?

I've written PowerQuery script that iterates all files inside a folder. For extracting individual file's data I've created PowerQuery function. Everything works fine in Power BI Desktop, but when I publish the report into Power BI Service and try…
Alexander Chernov
  • 31
  • 5
1
vote
1 answer

Power Query call to google.webmaster.api , Post, request problem

I call the google.webmasters.api via Power-Query(M) and managed to configure the oath2 and made my first successfull call to get & list. Now i try to call the /searchAnalytics/query? which is working only with Post. This always responds in a 400…
JB.Baxter
  • 11
  • 2
1
vote
1 answer

Updating a table from a power query changes formula reference

Saw this was previously asked here on SO and had no solution and I can't find a solution through Google either. I have a workbook with a tab called "Data" containing a table which is updated via a power query and another tab called "Calcs" with…
erik7970
  • 693
  • 1
  • 8
  • 21
1 2 3
…
99 100