power

  1. M

    Importing files with variable number of columns

    I noticed something odd today and I don't know if this is new or if I just never encountered this before. I have 3 files in a folder and imported from the folder into Power Query. 2 of the files have 2 columns, 1 file has 3 columns. Power Query imported just the first 2 columns from each...
  2. W

    Calculating time differences

    I have a Start Time and Stop Time column in my Excel spreadsheet that is feeding the Power BI reports. Time is entered in military time, however I cannot make Power BI Calculate the difference properly when the Start Time is one evening and the Stop Time is the following days morning (i.e...
  3. S

    Power Query - insert column by repeating single value from another query

    Hi, I have a power query qryTotalSales that simply has SalesAgentID and SalesVolume as an aggregate SalesAgentID SalesVolume 1 27 2 4 3 72 4 11 In another power query qryThreshold I have restricted...
  4. H

    Help with Macros

    I very new to using Macro. Can some one please help me with a code to open all the below applications once I run the Macro. Calculator Adobe Reader DC Cisco Jabber Microsoft word Micrsoft excel Microsoft power point Microsoft outlook Snipping tool Notepad Any help is really appreciated Thanks
  5. W

    Auto Refresh Power BI

    I am using an Excel workbook with several tables to create a Power BI Metric package that publishes to an internal SharePoint site. The employee responsible for updating the Excel workbook is not capable (via access or skill) to refresh the Power BI dataset. How can I automatically get the Power...
  6. S

    Missing power query functions

    Hi, I have a Excelfile with a power query model in it. It works fine on one computer, but when I run it in on another computer there are errors. I use excel 2016 on both computers but the one with errors crashed a couple of weeks ago and got office reinstalled just the other day. The error...
  7. R

    Power query not updating

    Hi - I have a problem with power query not updating all data from my source file. My query was created from file / from folder, and I currently only have a single file in that folder at the minute. I have imported that data into power query with no issues currently, however if I change some...
  8. L

    How do i create this DAX table in Power Query

    I every one, i have a problem... I have created a table in dax, like this NISCountLT2 = SUMMARIZECOLUMNS(LT2[ID]; "Total"; COUNT(LT2[ID])) to count repeated IDs then i use this code to create a column with ranges for the report Bucket Range = SWITCH( TRUE(); NISCountLT2[Total]=1;"1"...
  9. L

    To analyse Quarter monitoring from companies into power bi

    Hi All Good Morning I have been asked to analyse Quarter monitoring fromcompanies into power bi The monitoring forms are in excel format with for Q1, and the other tabs would have Q2, Q3, Q4 tabs. the monitoring formformat does not change for each quarter. The information is input into...
  10. L

    Power Pivot Error "Many to Many" Error Is Incorrect

    I have a Dimension Table and a Fact Table brought in by Power Query. In Power Query, I added a Calculated Column to each table named "Report_ID". I'm trying to create a relationship in Power Pivot for these tables, but I keep getting the error message that Power Pivot does not currently support...
  11. L

    How to combine values from 2 columns

    I everyone! i have a problem, I want to create a single column from the combination of 2 others from diferent tables... these columns have a null value or a numerical value, like this: COLUMN_TABLE1--COLUMN_TABLE2 ----- WANTED COLUMN_FROM_ANY_TABLE...
  12. D

    Streamline Power Query for Excel

    I am just discovering the power or Power Query for Excel I need to run merge queries to populate data on my daily file from the same master file every day and am trying to streamline the process. My current process Open my daily file Get & Transform From Table/Range In power query editor.. New...
  13. R

    Power Query - Re-merge a column

    I am pretty new to Power Query so please be gentle! I have a table with 2 column's from a database. The first column is a Parent recipe, the second column is a Child recipe. Recipes will be found in both columns so no unique records. Example: PR CR A B C B D C E...
  14. L

    i need to replace some values in a column

    Hello, first that all excuse me for my bad english ;( I need your help, im new with power BI I have a table named LECTURA that contains a column named SMS. The column SMS have a lot of values, and i need to change the value of a part of it. The values i need to change have the structure...
  15. S

    Scheduling Possibilities?

    Hello, I have Power BI Pro installed as part of our E5 license and I am trying to evaluate it in thoughts of using it instead of our current IBM Cognos setup (that we pay extra for) fo rquerying our SQL server tables... However, the one concern I have that I do not think Power BI can do - but...
  16. A

    Power BI Certified Courses

    Hi, my company is prepared to put me through a Power BI course and have asked me to find a course that fits our needs: > Preferably a week / 2 week classroom based intense course > Certification included, Microsoft 70-779, MCSA or MCSE exams as part of the course > Preferably a Microsoft gold...
  17. A

    Countif in power query

    Hello How do I execute the following code in Power Query? =IF(COUNTIF($B$2:B2,B2)=1,1,0)
  18. L

    Power Query Does Not Import Multiple PDF Pages

    Hi, I'm using Power Query for Power BI Desktop and when I connect to a single PDF file the last record only shows the data for the first page and not the rest of the pages. The rest of the data is the same as the first page. Can Power Query read multiple pages for one PDF? If so, how can I...
  19. R

    Check to see if sheet exists before Power Query consolidation

    Hi there I have about 40 files that I need to append through Power Query. In my model the user selects a month and then the sheet with that month name is consolidated. It works great until someone uploads a file that doesn't have any sheets with that month name. How can I get power query to...
  20. Z

    SSRS - Power query connection, refresh only PQ

    Hi guys, I managed to create connection from SSRS to power query, but our reports are slow and based on connection method I need to refresh PQ queries after Power Pivot connection, is there some macro/ option how to do it without clicking at every query manually? And ideally without refreshing...

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top