This is a long shot. I've set up a connection to a website that pulls historical data into a table in my spreadsheet. I've used the URL below to create the connection/query. My question is is there anyway of automatically updating "end=20180115" so each day when I refresh the spreadsheet...
I have an Excel xlsx workbook generated by a export from a IT system. I'm trying to leveraging Excels awesome Query language feature do some ETL operations before the data will be sent on to another system.
I'm stumbling on an issue that my source data is interpreted as numeric data when...
I'm new to Power BI and Power Query in Excel (right now I'm working in Excel 2016). When working with the Advanced Query Editor, I have learned I can invoke custom functions I've built in the M Query language, so they run on columns in a table and generate a new column that holds the results of...
I'm new to this forum and a bit stuck, when I work with the Query Editor in Excel 2016. Editing in the advanced expression mode, which I understand is using the M query language, I get errors about Token Comma expected when I makde a custom function using the code below.
Its adding the row...
Hi, I used the Microsoft Query to access data from an access DB that I maintain. when I import it, I view the data in the Wizard tool and it has the correct data but once I close out of it, the data that is imported into the Excel (in table form) is not right. Particularly any columns that have...
I inherited a report and I am not sure how to fix it. I am trying to debug this set of workbooks that have lost connection through the data model and keep getting the "Object reference not set to an instance of an object" error. I have 10 tables that are all doing the same thing and 3...
I am trying to pivot columns with repeating data to rows. However as I have duplicated information in the Data column when I Pivot (Don't aggregate) I get the following error message.
Address Line 1
29 Acacia Road
Address Line 2
I am using Office 2016 64 bit and running into a problem with the Table Properties in PowerPivot. When I import a file (from Excel), but forget to include, exclude a column or set a filter correctly on the initial import I use to be able to go to Design->Table Properties and modify the import...
I love having the navigation pane in the query editor so I can go back and forth between queries without loading them. However, I've been losing some work from time to time* and it occurs to me to wonder when and how these changes get saved.
If you go in and group and rename queries, do you...
I have a workbook with several tabs.
One tab is called master.
I then have another tab called summary sheet.
On the summary sheet i have several tables which are all queries looking into the master tab.
This is all on one computer and works fine. however if i want to put it on a usb the...
I have imported a txt file in to Query editor, separated in to two columns and cleansed the data to give me a data set with 31 unique row labels in column A and the information in column B. (see below)
Is there a way I can transform this data within query...
Hi there I have the following Query and I want the user to enter Start Date in Excel that will trigger the Query.
is it possible to it?
SELECT Problems_ProblemLog.EntryNo, Problems_ProblemLog.RejectID, Problems_ProblemLog.ProblemDescription, Problems_ProblemLog.ActionDescription...
I Have a workbook which consists of 50 worksheets and i use Edit query window to pull the data from oracle on all these sheets. We run this once in a month. I have to go to every sheet and execute this code which is time consuming and i have to change the date value everytime.Please help me with...
Thanks in advance for the assist.
I am attempting to create a calulation within a query that says the following: Fixed Days: field1+Field2
My issue is as follows: I need the query to perform the following in my Fixed Days calculation column.
If Field 3 = field 4, then Fixed Days =0, else Fixed...
is there a way or tool to see the SQL query in access in a structured and Indented way.
Its very tough to read a query in access.
Please share if you know any free tool, where if we paste the code, it automatically format and indents it and thus easier for us to read.