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,343
questions
0
votes
0
answers
14
views
Office 365 Power Query framework for developing Excel Add-in [closed]
enter image description here
I want to build the similar framework to display the Data on selection of a cell either of the language. Please refer the attached image.
Can someone recommend me how can ...
0
votes
1
answer
22
views
How to streamline else if statements in Power Query M for a new Add Conditional Column
I created a new Conditional Column named [CATEGORY] based on many different values in a column named [MERCHANT].
I'm categorizing the values in the MERCHANT columns.
Many of the values in MERCHANT ...
0
votes
1
answer
26
views
I want to return the max value of a row and then return the header in Power Query
I want to be able to return the maximum date of a row, but I want to return the heading of the column rather than the actual date. But, I want it to write the heading instead of the date. For example,...
0
votes
2
answers
43
views
VBA: Editing Power Query M-Code using VBA
I have a shared Excel file with a Power Query that extracts data from an external local file. However, several users work with the shared file and they need the Power Query to access the local file ...
0
votes
1
answer
19
views
Conditionally duplicate records and modify one column using PowerQuery/M in Power BI
I'm using PowerQuery/M (well ,trying, this is my first time having to go beyond the basics) in Power BI. I have a json file representing a tree like structure, which I am trying to flatten out.
The ...
0
votes
1
answer
16
views
Replicating rows with changes to certain columns in power query
I'm trying to create a dataflow with power query for currency conversion rates. I have an excel file that has the rates I need, the issue is that the rates for the current month aren't updated until ...
0
votes
0
answers
24
views
"we couldn't authenticate with the credentials provided" error in Power Query
I'm trying to get data from an API with bearer token authentication. I call this REST API successfully on Postman, but when I input it in Power Query, I get this error:
We couldn't authenticate with ...
0
votes
0
answers
15
views
Power Bi Integration with Rest API using selected slicer values
I have a deployed ML model. I am using a Flask app to use the model and return predictions. It is a post request which input payload in this form
{
"input_features": [
feature_list1,
...
-1
votes
0
answers
22
views
update delta to static base table [closed]
i have a monthly report, which has a record of all tasks i have at hand on some system i use
every month i get new tasks, but also i finish some tasks
the report is an uptodate report, every month ...
-2
votes
1
answer
35
views
PowerBI DAX Calculate the total hours and minutes Per ID [closed]
I have a data that has employeee id, employe name, duration. I am trying to calculate the total number of hours and minutes for each employee based on their IDs for example
EmpID
Emp Name
Duration (...
0
votes
1
answer
43
views
How to create a dynamic dimension in Power BI
How can I create a dimension in Power BI that changes relative to selected condition. In this very case if a share of SKU is less then 10% out of total it gets a new name "other". I belive ...
2
votes
3
answers
91
views
Extract the start and end date of a sick leave in power query (gaps and islands)
I would like to have a max and min date of the different types of absence for every employee for project. I would like to have it in Power BI but I don't know how to do it.
There are 3 columns that ...
0
votes
1
answer
45
views
Power Query: how to sum up values in each column separately and get a new table with two columns: column_name, column_sum
help me please with such a task, please: i have a table
patient id
loc1
loc2
loc3
....
locN
3545
0
0
1
0
3546
0
0
0
....
3547
1
0
3548
0
1 ......
....
How can i sum up all numbers in ...
3
votes
1
answer
57
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
43
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 ...