power

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...

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

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...

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...

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...

Hi guys, I'm trying to merge about 3k text files into a single excel sheet. Now this is easy enough to do with power query or even some VBA I've seen, but I also need to add a column with the file name as each file represents a different day's information. I can't seem to find a way to add...

So there’s a monthly report we receive that is only a Pivot table (no tables or data anywhere, just the pivot table). So we have to go in and double click on grand total to spit the data out onto a new tab. Then we can save the file and throw into our folder that power Query is pulling from...

I am trying to extract data from a web page through power query, new query using excel 2016 but unsuccessful as it requires to login to access the web page , Anyone knows a technique to achieve this.:confused::confused:

I used Power Query to import file from folder. I then “close and load data” and a table appears. My question is this... Can I make changes to this table (deleting rows, etc) without having to go through Power Query editor? So far, whenever I alter the table in anyway, it will revert back to...

I have a spreadsheet with multiple claim lines per day for various events taking place per customer. I am looking for either a Power Query or Power Pivot solution to show all claim lines for only dates where a particular event took place on one of the claim lines. For example, if customer ID...

Is there a way to calculate the number of work days between two days? If so, how? Very new to Power Query...….

Hello I used Power query Connection to build the pivot table. The problem I have is that when I move the file to another computer running Excel 2010 or 2013, the pivot table doesn't work properly. My question is, can I add Power query module vba code to the file to work properly on any computer?

Hi, I have a table containing budgeted foreign sales data by month and want to convert this to a home currency (the fx rate is obtained via a parameter). Is it possible to multiple several columns at once in power query by a value? I know I can create new columns for each month and multiply...

Hi, In a database our timevalues are stored like 94500 = 09:45:00 121755 = 12:17:55 58 = 00:00:58 What is the best way to convert these when pulling them via ODBC? Ideally in the SQL query but power query is an option also. Thanks

Hope someone can help with this, I have a a csv text file that needs importing to a template then modifying using power query. Trying to find a way of being prompted with a dialog box for the source file so different named source files from different locations can be imported to the same...

Need to figure out a fix but have no clue how to do so. I've used this successfully before, really need it to work. Any help is appreciated!

Hi, I've been reading other posts here similar to my issue but I can't seem to get some of the workarounds or methods used to work. We had an intern working with us over the summer and he created a bunch of different reports in Power BI, I still have access to his account but my company needs...

I'm trying to get tables from a website which is password protected by username and password. It uses the classical web form with a "post" command to access to all the information so I cannot use Basic authentication. I've look in internet for a solution without success. Can anyone help me?

I have a complicated windowed running total I'm trying to calculate. I've made an excel example that I'd like to implement in powerquery so I don' thave to copy the formulas down. Here's an example file https://file.io/k7yZ4D

I am just starting to learn to use Power Query. I would like to delete any rows that do not contain "Err" and keep any rows that have no data in a certain column. If I was writing code in a macro, I would know how to do this but with Power Query I am really unsure, I know I can use the...