power query

I have this code in Powershell and I would like to have the same code in Power Query. Grateful for any help. $uri = "https://graph.microsoft.com/beta/security/securescores" $request = Invoke-MgGraphRequest -Uri $URI -method GET -ErrorAction Stop foreach ($item in $request.value) {...

Dear All, I have a file, in which the data tab fetches the data via Power Query in a table. There is second tab, in which we have to layout the data in a certain way to do some calculations for each employee based on the allowances they are getting. The complications are that certain allowances...

Hello I want to select columns in the worksheet and then merge them in PQ. The first part is done. The second part drives me crazy. I searched the web and the best I could find was this: Stackoverflow.com But it errors with: Expression.Error: Das Feld "NAME" des Datensatzes wurde nicht...

Hi all, I have several data files in a standard format (xlsx files, 1 tab (all named the same), 4 columns of data each (all common headers(Owner, Supplier, Amount and Account)) - varying numbers of rows in each. These files are in a folder on sharepoint (no option to save these outside of...

I have 2 data sources that come from the same application, but one is for Sales and one is for Invoicing. The columns are all named and formatted the same. There is a Custom Column in queries that use those 2 data sources where the logic is to be exactly the same...but sometimes out of sight...

Hi all, i have a date written into the SQL that links to the the data warehouse data source. Each month the user currently goes into the source SQL and changes this date manually. Does anyone know if its possible to create a user prompt on the front end dashboard so that the user can amend this...

Hey everyone, I am trying to add a new 24-hour time column to a one column table that contains only dates. The Date column is dynamically pulled from a database that provides dates for 30 days into the future. I am doing projection work, so there is no original time column for me to pull from...

Hi there, I was wondering if you help me transform the following dataset? This is how it comes out of the system: EmpNum ProductName InputName EntryValue Product Entry ID Emp1 Apples Type GrannySmith 123 Emp1 Apples Units 5 123 Emp1 Apples Type Gala 456 Emp1 Apples Units 3 456...

I have 3 total columns, Customer Job ID, Daily #, and Daily Date. I would like to update this M code to combine all distinct Daily #s sorted in order by Daily Date. Any assistance on updating this would be greatly appreciated. = Table.Group(#"Filtered Rows", {"Customer Job ID"}, {{"Daily IDs"...

Hi everyone, I want to make operations through Power Query. I am a rookie but I almost succeeded reaching my goal here but now I am stuck. I have 5 columns which gives for each technician, type of hours spent (work, holidays, ...), the number of hours spent, the date when it was spent and the...

Hi folks. About 3 weeks ago, I began to try and learn how to use power query, and while I think I'm slowly getting the basics, I cannot for the life of me figure out how to do what would be an insanely easy task in Excel. I have a fairly large database that I'm working with, and am trying to...

I have two files: bios v1.2.xlsx and departures v3.4.xlsx. Can Power Query compare the most recent versions of both files saved to the same folder and produce a list of names common to both? The exact match for comparison is: bios v1.2 -> ‘current’ tab -> “NameFirst”&” “&”NameLast” = departures...

I am making a Power BI dashboard and the data refresh of the power query has become unreasonably slow. The Source files are just 4 txt files (stored locally and less than 5MB total) which combined are less than 17k rows, so not large enough to cause major issues. The refresh was ok before, even...

Good day, I named a cell to "XYZ" and use it in Power Query as Excel.CurrentWorkbook(){[Name="XYZ"]}[Content]{0}[Column1] The question is, - if possible - how can I use a Defined Name in Power Query if it isn't refered to a range/cell but have an exact value? Thanks in advance!

Hi, I have a query with a column that looks like this: 2024-02-26T14:17:42.676231+01:00 If I change it to datetimezone type, it recognizes the parts properly and changes the data to this: 2024. 02. 26. 14:17:43 +01:00 However, when I load it to a table, the result is this...

Hi I have a set of date from a table that i need to structure and merge in to a resonable overview. user shall only choose project and date from->to i have used Power Query and pivot to streamline the data, but the selection part is not easy i nee uder to choose project subproject date how do...

Hello, I am getting data from an excel workbook within a folder Sheet has 3-4 rows at the top with couple of titles and blank rows, Then there is a table below these few rows. I am cleaning these few rows by removing them and then promoting headers from the table below. The issue is that some...

Hey everyone, I'm experiencing a problem with Power Query making a mistake in pulling an hour from a datetime. In the original table, the "Hour" column (2nd from left, in 24 hour format) is not there. I added that column by highlighting my datetime column in Power Query, going to the "Add...

Hi, Bit of a multi part question as new to PQ and PBI. I have an initial table of data storing audits by location, type, date and the score awarded. There are lots of things I want to eventually pull out/ display from the data but two main things to focus on: 1) Finding the most recent score...

Hi, Im doing a time measurement of cycle times per operator. The sheet use to track the time for each name has title rows that describe crane , lane, location where the measurement was taken (see image is the area in the red box). This is done per each operator. I'm trying to unpivot...