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
1 answer

Excel Get and Transform from web not picking up newly added columns

I'm using a Power Query to load in data from a Google Spreadsheet changelog capturing changes by a department within our orginisation. I set it up using the method of loading the data in via CSV. I generated a download of the sheet from the file I…
Bart de Brouwer
  • 41
  • 1
  • 5
1
vote
1 answer

PowerQuery with SSRS dataset connection

I would like to use an SSRS dataset as a datasource for PowerQuery, either with [Excel 2013] or [PowerBI Desktop]. The report server version is [SSRS 2016] [Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64) - Enterprise Edition]. …
SherlockSpreadsheets
  • 2,062
  • 3
  • 27
  • 47
1
vote
1 answer

Excel Parameterized PowerQuery With Null Handling

I'm encountering an error when attempting to execute a parameterized SQL query from Excel using parameter values (StartDate and EndDate) stored in a worksheet. When the EndDate parameter is left blank in the worksheet, I would like to utilize the…
Brett Wolfington
  • 6,587
  • 4
  • 32
  • 51
1
vote
3 answers

Excel 2016 Power Query fails to load to spreadsheet

I utilize Power Query with most of my spreadsheet due to analyzing a large Excel data files. This is the first time that I have had an ill-defined error in loading a Power Query connection to the spreadsheet. Excel Error - "Download did not…
Emily
  • 31
  • 1
  • 3
1
vote
1 answer

Sum columns in Power BI matrix

I am working on a matrix in Power BI and I am not figuring out how to sum each column recursively until the total: And this should be the resulting matrix (as an example, rows): Some clarifications: The months (columns) are dynamically generated…
Maramal
  • 3,145
  • 9
  • 46
  • 90
1
vote
1 answer

Power Query - Create and fill columns Email1, Email2 ... based on occurrence of email in cells

I have an "emails" table like this: Username Email john john@gmail.com john john@stanford.edu peter peter@gmail.com ... where one person can have multiple emails I want to construct a "people" table like this: Username Email1 Email2 Email3…
Lun
  • 428
  • 4
  • 20
1
vote
1 answer

Power Query - Data Transformation from a single column to a whole table

I have a requirement where I have a table like this - Actual Table with 2 columns Column1 Column2 ColAValue $$ ColBValue $$ New Row ColCValue …
Student of the Digital World
  • 2,971
  • 16
  • 62
  • 116
1
vote
1 answer

Load *.htm file saved as .xls (starting from row number 5) Using Power Query

I have to import an .xls file which is saved as .*htm, .*html. I attached a link which provides a sample file of that format. The Actual first row of the table starts from row number 5. But there are data above it. The file looks as below, The…
Student of the Digital World
  • 2,971
  • 16
  • 62
  • 116
1
vote
1 answer

Add column to matrix in Power BI

I am working with Power BI Desktop and I need to add a column to a matrix in order to calculate totals without adding to each column. This is my original table: I have two calculated measures: [Overdue Balance] and [Expiring Balance] that together…
Martin Fernandez
  • 368
  • 5
  • 16
1
vote
1 answer

Power BI Custom Connector logging not happening

I'm creating a Power BI custom connector in Visual Studio 2017 and I'd like for it to log during development. I've followed the approach in the samples and specifically in the TripPin sample under diagnostics. The diagnostics helper file…
Alan B
  • 4,086
  • 24
  • 33
1
vote
2 answers

Create a new column and have it display in number values

I have 1 file which has the following columns: Document Date and Disposition Date. In Power BI Desktop, I'd like to create another column called 'Duration' which can be calculated by taking Disposition Date - Document Date and I want the new column…
T D
  • 27
  • 7
1
vote
2 answers

Set column description from PowerQuery

PowerBI supports column descriptions (right click on a column and select properties), is there a way to set this column description from PowerQuery. It seems hard to believe this isn't possible, but I can't find it in the documentation for…
David Mulder
  • 26,123
  • 9
  • 51
  • 114
1
vote
0 answers

How to make an excel cell as a source file for a parameter for a query?

I have a query on Excel query editor from multiple excel files, I changed the source to be a parameter, and the parameter type is a text. it worked. then I checked if I can make the parameter source is a query from excel cell (Power Query Parameters…
Mohamed Ali Hefnawy
  • 21
  • 7
1
vote
1 answer

PowerBi Transpose - Table

I have an excel file that needs to be transposed from multiple columns into table format, but am having trouble merging the rows in Power Query. Sample Data Expected Outcome Thanks a lot for your help in advance.
Alf Miolan
  • 103
  • 2
  • 12
1
vote
2 answers

Copy all views from Linked Server into new database

In SQL Server Management Studio, I have a Server Object-> Linked Server where there are cube views. I am trying to make a copy of all of these views and save them on a separate SQL database on same server so that I can connect to these new views…
Matt C.
  • 2,330
  • 3
  • 22
  • 26
1 2 3
…
99 100