Most voted "powerquery" questions
11 questions
Sort by count of
-
2
votes1
answer8581
viewsWhat are the differences between Power Query, Power Pivot, Power BI?
I want to make a contribution to the community by presenting these free tools for data analysis using Microsoft and, unfortunately, they are little known and exploited by many and can be very useful…
-
1
votes0
answers90
viewsUse parameter that contains a current date formula at the data source
I get extraction files from the database in . csv format with default: C://director_staff/CSV_01-01-2019/file.csv A new folder is created every day, so to automate this in power BI, in the orgiem of…
-
1
votes0
answers36
viewsFunction in M (power BI) language for working hours
Good afternoon, everyone! I need a function in m language to verify that a call was answered within or outside the Deadline. For this I use the fields "resolution date" - "opening date", but I need…
-
0
votes1
answer269
viewsQuery Excel with cell criteria
I have a spreadsheet based on an SQL code powered by our database. But every month I have to enter the code and change the dates to get this information right. I want Power Query to use the values…
-
0
votes1
answer342
viewsRead data from an Excel cell to search via SQL
I need to execute an SQL that brings me a result of only one cell, but, I need to capture information of two. I will enter with start date and end date, my result will be a calculated value in that…
-
0
votes1
answer50
viewsUpdate Data Power Query and Copy Values by VBA
I need to update some cells in my spreadsheet as soon as an update in the Power Query table is done, but cells only update the second time I run the code. Sub AtualizarDadosPowerQuery()…
-
0
votes0
answers7
viewsPower BI Weighted Mobile Media
Hello. My personal doubt is how to calculate the weighted mobile average, in Power Bi, the problem is when I have to calculate the cost of the unit sold, multiplying by the average cost, and…
-
-1
votes0
answers4
viewsPower Query M - Can you have multiple queries in the same file . pq? (Visual Studio with SDK)
I am developing a connector, whose idea is to return N queries to the caller. I already varri the internet and several tutorials from Microsoft. Inside a file . pq, I have the following: Let…
-
-1
votes1
answer240
viewsFour/While condition in M language - Paging API in Power BI
Hello, I need help implementing a four/while loop in my api. Created this paged API below, works correctly, but in the OFFSET property, I need to stipulate the next number of the sequence, when the…
-
-2
votes1
answer194
viewsSearch by API / JSON - Latam and Gol (Power BI)
Good Morning! Guys, I’m riding a Dashboard on Power BI, and I need to link it to the Gollog and Latam load tracking site. I already have the link to search the web service, but I do not know how to…
-
-2
votes0
answers18
viewsExcel Help || POWER PIVOT
I am trying to learn how to use power pivot in conjunction with power query for obtaining and modeling data in excel. I was able to import the databases and include them in the excel data model,…