Most voted "powerbi" questions
Power BI is a business analytics solution that allows you to view your data and share information about your organization or incorporate it into your app or website, available individually or integrated with Microsoft Excel, Office 365 and all major databases and analysis tools. Used in projects for Business Intelligence application
Learn more…41 questions
Sort by count of
-
4
votes0
answers130
viewsPowerbi Desktop and error with R (GGPLOT)
I’m really stuck and I need help. After installing R 3.5.1, I get this error message in the R views on the Power BI Desktop I was working on earlier. "Error: package or namespace load failed for…
-
3
votes1
answer329
viewsPower BI Data Update
I have an SQL server and a chart ready. I am using Directquery. When I enter the Dashboard of power bi and I say 'update now', in the history, it appears as updated successfully. However, when…
powerbiasked 6 years, 1 month ago Daniel Godinho 75 -
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…
-
2
votes1
answer70
viewsDAX Filter Context - Powerbi
I have a simple spreadsheet for fuel supply control 3 columns: Date of filling KM Car Plate on odometer at the time of filling. I want to set up a measurement to know how much was driven in KM For…
-
1
votes2
answers334
viewsPower BI and SQL Server
I need to pass an integration budget to an SQL Server, but the work has a condition, the connection to the Power BI site, everywhere I read it does not make clear whether or not it is possible to…
-
1
votes1
answer1074
viewsPower BI - Best practice importing large amount of data
I’m new to the ID business, and I have to do the ID of just over 25 million records. The import to Power BI is not feasible, since the file would be more than 1gb and it would be impossible to post…
-
1
votes0
answers47
viewsCumulative Total 12, 6 and 3 months
I need to enter below my total, a cumulative total of 12,6 and 3 months. The base I use contains a column called competency to group. I actually created another table to put these 3 rows of…
-
1
votes1
answer1301
viewsSort per month in power bi
I have an excel spreadsheet that gives me something like Contrato Jan/2018 Fev/2018 Mar/2018 2010100 15.800,00 9.000,00 15.000,00 2010101 10.000,00 10.000,50 11.000,15 Right after I made a unpivot…
powerbiasked 5 years, 6 months ago gabrielfalieri 1,231 -
1
votes1
answer193
viewsChanging the name of a data set field - Powerbi
Hello I have a data set (Excel) that was loaded in Powerbi. When I change the name of a column/field in Excel Powerbi does not actualize the data because it does not recognize the name of the column…
-
1
votes0
answers205
viewsAuthentication on a website for viewing Power BI reports
You can log in to my website and use username (or e-mail) and password to automatically log into Power BI, creating a session or using some API? I would like to incorporate Power BI reports with…
-
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
votes2
answers478
viewsFormula to Count Boolean Values Power BI
Good evening, everyone, I am trying to make a Count with boolean values in power bi, using DAX formulas, but formulas do not return any value in the graphs. Does anyone know how to tell the problem…
-
1
votes0
answers74
viewsHow to predict the various statistical models generated in R in Power BI?
I trained several models in the R, like these: iris2 <- data.frame(zzz= sample(c(0, 1),size = length(iris$Sepal.Length), replace = TRUE), iris) for (i in unique(iris$Species)) { saveRDS(glm(zzz ~…
-
1
votes1
answer58
viewsLowest value (DAX variables)
I need to create a measure (MAX) that calculates the smallest among several variables, also what we have in Excel called "SMALLER"... My attempt is as follows ("Unsuccessful") M_Teste = var v1 = 10…
-
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…
-
1
votes1
answer48
viewsHow to Capture Data with Pandas?
I work with a database that uses frequency, and I want to analyze the frequency data and transform it into several lines. Follow image example: I want to make line 6, for example, become 6 equal…
-
1
votes1
answer46
viewsError publishing Power BI report on Workspace
Good afternoon I have the following structure mounted on my personal machine: SQL Server -> Server Analysis service -> Power BI -> Power BI report published on the Web. Everything works…
-
0
votes2
answers1070
viewsFormat SQL data inside Power BI
Is there any DAX formula that can change the date format imported by Power BI services and maintain the same date format, or leave in some date sorting format?
-
0
votes2
answers729
viewsPower BI - Oracle SQL Query
Hello, I am trying to get data in Power BI via Query on an Oracle DB and is showing the following error. Cannot establish connection Details: "Oracle: ORA-01843: not a Valid Month" SELECT DISTINCT…
-
0
votes1
answer352
viewsHow to create a measure to count different numbers?
I’m new in this world of power bi and I’m in need of a help, it may be basic what I’m going to ask. I have an excel spreadsheet that gives me more or less to structure down. Protocolo Pedido Item…
powerbiasked 5 years, 8 months ago gabrielfalieri 1,231 -
0
votes0
answers65
viewsField ordering in Power BI
I have three camps in my Cartão de linha múltipla (This is the translation in Portuguese): Account, balance and % sale. However I need to sort by the order field, which is not in the Campos of the…
-
0
votes1
answer104
viewsHow to add days in a date with the format dd/mm/yyyy in powerapps?
I’m taking a date from a table and adding days on the count in powerapps. Apparently on the computer works, but when I use the powerapps app on the phone doesn’t work, the date comes changed,…
-
0
votes1
answer1209
viewsDifference between multiple dates in the same column
I have the following problem.. I have the following table: I want to create a calculated column that tells me the difference of days between two dates of the same code (COD), the difference shall be…
-
0
votes1
answer148
viewsDo Not Show Blank Value with DAX
Good morning guys, I’m trying to create a function on DAX that instead of showing the value Blank on my Dashboard, show the value 0. But my power bi are returning me the following error: **` The…
-
0
votes1
answer162
viewsFormat Switch in Power BI (DAX)
good night! I’m new to DAX and I’d like a hand with the following question: Meta Formatada = SWITCH (KPI.Formatacao , "Money", FORMAT([Meta],"Currency") , "Numeric", FORMAT([Meta],"General Number")…
-
0
votes1
answer466
viewsAbout DATEADD, comparison with previous month when there is a single month filter
I have the following situation as shown below. I want to make an individual analysis of the month, so every month that not selected are with filter 'off' and this makes my measurement with value:…
powerbiasked 4 years, 4 months ago Flávio Ravier 5 -
0
votes2
answers127
viewsMicrosoft Power Bi - Filtering in back-end
Hello. I am starting to study Microsoft Power BI now, and would like help on a question. First I created an excel as a data source: Then I created a data set and a report: All right so far. I’m…
powerbiasked 4 years, 3 months ago Gustavo Souza da Rosa 13 -
0
votes1
answer100
viewsPower BI and Python - Incomplete Script Result
Hello, I am trying to return the link list found in HTML with the python script below. When run in the Python IDE, the result returns all found occurrences. When running on Power Bi Desktop, the…
-
0
votes0
answers9
viewsConditional column construction with date comparison
I need to create a date column with a condition for comparing existing dates in the "Start Date" column for the same type of equipment. That is, for equipment 1, I need to return in the first row of…
-
0
votes0
answers8
viewsDAX - Searching for keywords in sentences using DAX language in Power BI
I have a problem regarding DAX in Power BI. I need to categorize the locations according to sentences. I have mapped the keywords as image attached, but do not know how to search for them in the…
-
0
votes0
answers48
viewsI need to calculate the date difference in the same column - DAX PBI
I need to know how many days it takes a customer to make a new purchase, IE, what is the difference between purchase dates. I used the logic cited here as a possible solution, but without success:…
-
0
votes0
answers7
viewsChange the start and end date reference of a month in Power BI
I need to create filters in Power BI Dashboard in which the month of August, for example, starts on the 20th of July (previous month) and ends on the 19th of August. This should be done for all…
-
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…
-
0
votes0
answers8
viewsWeighted Average Cost
I ask it is possible to develop this account in power BI or Query, I already passed by other groups and I was told this, it seems simple but a kind of loop. The first 4 columns are part of the base,…
-
-1
votes1
answer4320
viewsPower BI - FILTER CUMULATIVE VALUE WITH SEVERAL CRITERIA
I have a stock database with four columns: Date - Product - Entries - Sales. 1) The 1st column contains the dates, all of them always with the 1st day of the month and year: 01/01/2010 - 01/02/2010.…
powerbiasked 5 years, 6 months ago Paulo Semblano 85 -
-1
votes1
answer839
viewsPower BI - ORA-01843: not a Valid Month
I am making a query in PBI via a View. However, no matter how much I modify the date format, it does not accept. The View is below: select NROREPRESENTANTE AS CodRepresentante, nroempresa,…
powerbiasked 5 years, 6 months ago Edson Sugimoto 1 -
-1
votes3
answers433
viewsCalculation with date filter and Ids, Power BI
Good morning, I need to create a measure that makes the following calculation: (Line value)/(Initial value) However the calculation should be done respecting the ID (not divided by values of other…
-
-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…
-
-1
votes1
answer71
viewsDisplay Visual Python in Power BI
When using the matplotlib library in Power BI the following error message appears: "Python’s process ended unexpectedly, so the look cannot be displayed. Try running it again." How to solve this…
-
-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
votes1
answer35
viewsBase Bi - MYSQL
It’s a layman’s question for being a situation I hadn’t encountered before. I have an instance of RDS Mysql with at least 22 databases. The current company needs to build a bi-model to consume the…