power queries

  1. S

    Large amount of files

    Hi, I have an excel file that is 80mb in size. I have daily files for several years that I upload each day. I would like to see if I could save time by storing prior years already. They are csv file format 365 files x 4 years and take 30 minutes to upload each day. I think if I could save...
  2. M

    Changing Columns in PQ (Excel) question

    Hi. I am a PQ rookie. If I have to change the name of a column is there a way to edit it all at once? I know in excel and vba I can do a control H and that gets me a find & replace dialog. But it doesn't seem to work in PQ editor. If there isn't a way to do that, is there a way to export all...
  3. M

    Auto-populate data from multiple sheets into one master sheet- Help

    I created 11 different tabs to be filled out. Is there a way to have the data in each of those sheets auto-populate into one master sheet? I need to show the totals of each product selected. I only included the Master Sheet and 2 tabs below. Thank you for your help. Master Sheet...
  4. K

    Power Query - data entry into Queries that also writes to Source Data?

    Hi So I would like know if this is possible or if there was another way to do this. I have a very large data source (750,000+ records) in an excel file. I would like to create subsets of this data based on which team it is allocated to. This is the easy part for me. So I have Team 1, Team...
  5. M

    Sumifs and power query Sumifs

    I wonder why in the normal Sumifs formula it will ignore the zero at the beg. of an invoice no., while sumifs in power query using aggregate won't ignore it For Ex. Sumifs between bank Data and ERP Data will show the below invoice as matching although in the Bank data the invoice doesn't have...
  6. F

    Power Query IF Time is

    Hello, Is there a formula to use in Power Query for (If time is between 7PM and 7AM then After hours, if not then Business hours?
  7. N

    PowerQuery Automation

    My question is this, is there a way to automate power query in vba, for example if I record a macro of me getting data from a PDF I open the pdf in power query I choose the option select multiple in the menu, I choose two pages and then I load it to a table. But when I go back to the macro, all...
  8. S

    Connecting A Power BI Dashboard to Excel

    I have been able to connect data to excel using publically available APIs and Power Query. Stuff like data from this page and an API like the equivalent downloads for UTLA API. I get data from a Power BI dashboard but they don't have a publically available API like the data above but copying...
  9. N

    Copy/Record Table Data to New Sheet after Power Query Refresh

    Hi guys, I hope everyone is doing well! Just a quick question, I have a table on Sheet 1, with data that is populated using power query SQL source. My apologies if my question is a little confusing, I wasn't really too sure how to word it. What I'm needing help with is somehow making it so...
  10. V

    How would I go about copying a value from a cell given certain conditions?

    I have a table with a customer and a bunch of line items tied to the customer, and then the next customer and a bunch of line items. Due to the way the information is received there are blank values between customers. I Have CUSTOMER PRODUCT QTY Customer A ABC 20 XYZ 5 LMN 15...
  11. S

    Create Multiple table from 1 table

    I create a table (Table.A) from web source. I want create table.B not from web source, but from exact data in table.A, so when refreahing table.B, it get content from table.A. P.s: I tested connection reference, but every sub connections use Internet as source of data and just get structures...
  12. S

    Filter Table.SelectRows from cell rang in sheet

    I Imported some data from folder. folder has 100 txt file. I need select txt file based on names listed in column2 at sheet2. Originally they are selected manually in power query and code is like that: let Source =...
  13. K

    Party name According how many invoice to Show count , But Not Show count Total Invoice

    Show Result : 3 (Pleased Show this Query........................................)
  14. T

    Links failing to update when power query is refreshed

    Hello Mr. Excel Friends, I have a few sheets linked to a master data sheet via power query. I had added some columns to the master sheet, but when I refresh the queries on the other sheets they do not update to include the new set (for example there was a table that initially had 23 columns...
  15. R

    Should I connect to 195 external data (excel files)?

    Hi I am new to power queries. I am a teacher and try to accumulate all the score for the whole school. I have 15 subjects and each subject have 15 classes to pull the score in. My goal is to be able to receive all the subject scores for each classes(15 sheets in 1 excel). Something like this...
  16. J

    EXCEL: Extract 5 Specific Cells from Multiple Files From Multiple Folders Into One Master Excel Table

    Hi there. SCOPE: I have automatically generated reports that need to have 5 specific cells extracted from hundreds of workbooks, in multiple different folders. All values must be formatted as one row with the source information included, such as filepath and filename, into one master list...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top