query

Hello All, I am working on a project and I want to know which one supports a query editor between Power Bi and Tableau? According to a source, Tableau does not support this feature may be and I have no idea about power bi? Can anyone explain to me who supports query editor?

Long story short, I managed to push data from "public" websites. Quite straight forward process Data > Get External Data > Run Web Query and I get the data I want. My problem is how to do this if the data I need to access is personalized for a single user. I do have access to login details and...

Howdy! Since I see update speed benefit in it, I typically use Table.Buffer in all of my queries by wrapping the very last line. Example Source = #"My Data" in Table.Buffer(Source) as table However, when someone else uses the same template file on their machines, the queries won't refresh...

Hello, How can I rename a query (not its shortcut)? I've a query that is part of a 'Group' under 'Custom' category in Navigation pane. When I right click on the query I see option of renaming the shortcut. How can I rename the actual query (not only the shortcut)? I am using MS Access2016...

Hi All, I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one. In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...

Hello, I use a dynamic table which absorbs data from a query regarding the name of sales agents, names and codes of (their) clients, and hours left from a pack. It can be updated to reflect the new amount of hours left, and I can filter by name of salesperson to show only their clients and the...

Hello All, I am completely new to access and was trying to do this with Excel Power query and was successful however the data is so large that it is taking forever to run, so I decided to give access a go. Here is the situation, I have 10 locations I manage and each day I receive a csv file for...

This has probably been posted but I have been looking for it confused for quite some time. I'm quite new to access - have written a few queries but am looking for a solution which doesn't seem to fit anything I have found as yet. I have a database with linked tables with 1 to many...

Hi There i am new to using MS Query, i think this should be a very simple answer. I am looking to display all of the order numbers that are beginning with W, but do not include those with a '/' in the order number. I started by doing Like 'W%' which works for the first part. How do i then edit...

Hello, I have a large excel file with over 50 columns that is out of order when i downloaded from web. So web content management system scrambled all the columns, and when export to excel, all columns are out of order. Original data is a Form responses that exported out to excel...

Good day, I would like to solve this problem using formula, query, or pivot. My company is issuing invoices. Most of them charge audit service fee and outlay together, and a few of them only charge outlay. I cannot think of a logic to distinguish them in the format I expected. Please help.

I am using the query function with 3 different ranges within 1 formula, Where i want to Select a column if Column X = to a 'Name'. The problem i am facing currently is that the first 2 Ranges are give me back 2 Null values since it cannot find the name and the 3rd range contains the name. I am...

Hi Folks, I am stumped. I am trying to merge two tables into a new table using a LEFT JOIN. Both tables have unique records on each row. When I join the tables, BI creates duplicate rows on some records for no apparent reason. The duplicates are identical in every way. I followed the steps...

#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated) how to possible get data as a list format, NOTE: SHEET 1 : *** So many Space in there*** SHEET 2...

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

Hi All, I am using Mac and my team is using windows majorly. We have excel where windows user are able to see the data without any issue but i am getting #REF! in most of the cells. Weirdly , when i opened another excel which is connecting to DB and getting the data and then opened the above...

I'm trying to import txt files into excel. All of the text has the same pattern. That's why I want the content of each file to be in a single cell, so later I can use "Add column from example" to extract the piece of information I need. However, the content was imported into multiple rows for...

I need to load records from another excel file into another based on a range of characters. The user can enter the first and last into two cells with corresponding ranges (firstone, lastone) From these two values, I need to do a power query to load in the data where the customer name is in...

Hi all, I've searched around but can't find any instance where this problem has been solved. I've got some queries set up in Excel (2016) that get stock data for the day from a website. Typically I'll open the workbook and hit refresh all, and the data loads. Today, though, it's loading...