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.
powerquery
6,330
questions
1
vote
0
answers
34
views
Ignoring error in Table.ExpandTableColumn or auto-replace with null
I am loading 100s of XML files from a folder and Power Query has created a function from the first file I had loaded. The problem is not all the XML files have a similar structure. Some have nodes ...
1
vote
1
answer
24
views
Is it possible to transpose a table when the number of items in each column varies and are unrelated to what is in other columns?
Is there a way to transpose a two column table so that the values in one column are the new column names and the values in the second column are listed under them in ascending order.
enter image ...
- 11
0
votes
0
answers
8
views
Clear previous value selected PowerBI slicer on change from another slicer
I've 3 slicer in powerbi for referenceId, lower version, higher version.
On selecting reference id I see some versions value available in other two slicer. I've un linked the versions slicer from ...
0
votes
6
answers
81
views
Multiple Conditions in Excel considering the table2
I have a data set contains city names.
Table1:
Table2:
I want to apply the Table2 condition .
Exclude USA means "<>USA"
I can do it without considering the Table2 by taking the ...
- 23
-2
votes
1
answer
40
views
Load data in new sheet using existing sheets in Excel using Vlookup or power query
I am working on an excel book which does have two sheets sheet1 and sheet2. This is a large data set consist of more than 20000 records. I could not get this figure out.
Sheet1 columns:
RecordID | ...
- 69
0
votes
1
answer
35
views
Excel Power Query - how to handle error when get data from web
My end goal is to pull 2 data points from internal company url and display it in excel.
end goal
Typically, there are 2 types of "Data_Response_Code" - 200 and 404.
My idea is to first use ...
- 3
0
votes
0
answers
18
views
problem with import text in pdf by power query (right to left language)
if i convert ".pdf" to text & use get data from ".txt" or ".csv" file & set file origin on "1256:Arabic (windows)", then i have a correct text in PQ.
...
0
votes
0
answers
32
views
Power Query Pagination when the cursor reference for the next page is given as part of the initial JSON Response
I know this has been answered several times with a loop and a variable to hold page size and count, but the API I'm trying to use doesn't have those parameters.
In my API Call:
https://someserver....
0
votes
1
answer
17
views
Power Query: Error on dynamic file path for txt file
I wanted to develop dynamic file path for txt file but it keeps giving me error on the "filecontents" step below:
let
Source = Excel.CurrentWorkbook(){[Name="FolderPath"]}[...
- 1
1
vote
2
answers
43
views
In Power Query, how do I calculate difference between numerical values of two rows in a table?
A Power Query / BI newbie here. I have the following sample data table:
DateTime
Process
Activity
ElapsedProcessTime(s)
TimeInterval(s) (expected output)
17/Jul/2024 00:00:00
A
1
0
0
17/Jul/2024 00:...
- 23
0
votes
0
answers
18
views
Filter as Multiple combinations in Power BI
I have a database loaded into Power BI.
One of the columns contains long text.
I would like to implement for users the possibility of filtering through a search field that allows the combination of ...
1
vote
1
answer
20
views
Power Query - Add column with path for each file
I have two queries (working) hat do exactly what I want:
they scan a folder for DBF files with a particular name
convert each one into a table
combine the tables into one long table
I want to add a ...
- 437
1
vote
3
answers
36
views
How to identify slabs based on a config table in SQL or excel
I have 2 tables, a Transaction table and Config table.
Based on the percentage achieved, I need to identify slab and rating from the config table.
Config table values can undergo changes including ...
- 1,323
1
vote
1
answer
17
views
Power BI Remove year in Chart visual x-Axis but sort by month and year
In my data I compare the sales amount of diferent years but to show them in the same chart, I faked the year in my data. It always start in 2000.
The legend shows the name of the SalesEvent.
My ...
- 424
0
votes
5
answers
56
views
How to transpose subset of columns into rows and group by remainder of rows? Excel? SQL?
We are in the early stages of migrating some data from a legacy system to a new system that seems to have some quirks.
Currently we have some data that is as follows
Name Date Award
Roger ...
- 155