power

Hi All, When loading data there is a column under number format but some starts from A and a space therefore power BI treats it as error, what would be the best way to fix it? I am thinking about fix the source excel data change it to text and add a apostrophe otherwise it shows scientific...

Hi all, I import GL transaction data in CSV form and the one error I can't fix in PQ is the date column (e.g. 4/30/19 which PQ won't accept as a date). That's the format out of the GL. When I do a simple Replace ("/19" to "/2019") it makes it a recognized date for most rows, but some dates...

I have a sheet that I am entering in values for to layout power requirements. My table has a colum for Devce Name, PDU Location, Max Power (W), Max Current (A) [this is automatically calculated based on he power field divided by 120V], Breaker value [auomaticly looked up based on a defined list...

Hello, I am fairly new to Power Query and have searched but can't find a solution - every thing I find is related to listing files, not folders. Is it possible for power query to just list folder names from a path? I can list all files with the path and extract the folder name but removing the...

All; I am looking for a way to open an XL file with a button in Power BI. We use Sap and the version we currently use does not allow for Power BI to go and get the data. So we have several different vba codes that extract the data from SAP through RFC calls, scripting etc. which leads us to an...

I have tried to set up a formula on Sheet4 to compute the Net Value in Col G (it is the value in Col E-Col F eg E2-F2) it would be appreciated if someone could kindly assist me...

Hi I have found a way to merge all tables as one using G&T (Power Query) however I need to transpose each table ahead of merging as my data isn't structured correctly. Code: [View] =Excel.CurrentWorkbook() I have about 50 tabs which have a table on each where I need to run the same query and...

Does anyone know of a way to keep notes on what each step does in Power Query? When I write VBA, I write up a detailed explanation of what each line of code does so if anyone needs to modify it they can understand the method to my madness. The closest options I can find in Power Query are...

Hi All, I have a sheet name "Data" it contains the output table name "Raw_Data" which data comes after running Power Query. Now I am looking for a VBA code which POP up and ask where to save file and after that copy the data from "Raw_Data" table and paste it in a new file. I tried with...

I used powerview in excel 2013 and excel 2016, but I dicided to upgrade to office 365 rather than office 2019. Has Microsoft dumed down office 365 and remove power view? To installe office 365 I had to remove office 2016. Is there a way to ***** about this. Richard

Hi, How to open a password protected workbook through power query? Thanks in advance for a help.

I have an Excel Table. I then selected add to Data Table Is there a way to retain the data table when opening the file again ?

Hi, I have an Excel file (in old format, let's say A.xls) that is produced every night from the backend databases and it contains 33 worksheets, that are lists (Power Query reads them as tables but with delay until it opens all tables). They contain records from a few dozens up to 10000...

Good day, Excelsiors, I am using Power Query to run an API call to our service provider, in order to pull through our platform users and their attendant data. The idea is that we would like to keep a "real time" register, rather than keeping a separate, manually updated register which is...

Hello, I want to get the table containing currency rates from the following web site: www.cbar.az/currency/rates Though Power Query does not return a table, but HTML parts. Is there a way to get the table from the mentioned web site? Best, AH

I am attempting to become more efficient with a process I do monthly by utilizing Power Pivot (which is new to me) verse excel and multiple formulas. All of my data is in one table and I'm attempting to replicate the formulas that have been created for use in excel for use in Power Pivot...

Hi, As per the question above is it possible to import a pdf file and manage it by using Excel 2010 power query, I've tried but so far failed. I'm assuming it's not possible? Thanks Mike

Need some suggestions on how to repair the connection to the data source after updating Power Query. Typically I would pull in data from a folder off a server, however this is my first time making a connection through an Access database. I have pulled in several data sets from an access...

Hi, First time using this. What am I doing wrong that brings about the errors in attached image? https://www.dropbox.com/s/mo6gk6kigrts0me/asas.png?dl=0 Thks,