Questions tagged as 'powerbi'

1
answer

Power BI Data Update

I have a SQL server and a graph ready. I'm using DirectQuery. When I log into the power bi dashboard and click 'refresh now' in the history, it appears as updated successfully. However, when accessing my graph (published on the web) they are...
asked by 15.05.2018 / 17:07
1
answer

What 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 are little known and exploited by many and can be very useful in our widely used automation and reporting work toda...
asked by 31.01.2018 / 23:57
0
answers

PowerBI Desktop and error with R (GGPLOT)

I'm really stuck and need help. After installing R 3.5.1, I get this error message in the R views in Power BI Desktop that I was working on previously.    "Error: package or namespace load failed for 'ggplot2': package   'scales' was insta...
asked by 07.12.2018 / 19:52
1
answer

Order by month in power bi

I have a excel sheet 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 Soon after I did an unpivot...
asked by 20.12.2018 / 13:15
1
answer

How to create a measure to count different numbers?

I'm new to this power bi world and I'm in need of a help, it may be basic what I'm going to ask. I have a spreadsheet in excel that gives me more or less structure. Protocolo Pedido Item ACC003.2018.PRISMA.1777395...
asked by 22.10.2018 / 16:40
1
answer

Difference between several dates in the same column

I have the following problem .. I have the following table: Iwanttocreateacalculatedcolumnthattellsmethedifferenceofdaysbetweentwodatesofthesamecode(COD),thedifferenceshouldbecalculatedbasedonthedatebeforetheline.Forexample:UsingCODBCOD|D...
asked by 04.01.2019 / 19:40
1
answer

Power BI - ORA-01843: not a valid month

I'm doing a PBI query through a View. However, no matter how I modify the date format, it does not. The View is below: select NROREPRESENTANTE AS CodRepresentante, nroempresa, seqcliente, skcategoria, count(distinct se...
asked by 27.12.2018 / 15:44
0
answers

Blank comparative filter in Power Bi

Hello, I created two filters to make a comparison by duplicating the facts with the records for the measurements and the tables that make the filter with the proper relationships. However, for some reason, when filtering through a specific filte...
asked by 20.12.2018 / 13:36
1
answer

Power BI - ACCUMULATED VALUE AS FILTER WITH VARIOUS 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. Dates start on 01/01/2010 and run until 01/11/...
asked by 07.12.2018 / 14:30
0
answers

PowerBI Report Server Data source Sharepoint

Hello, I'm having trouble setting up a spreadsheet made in PowerBI RS (August 2018). When I'm creating I can connect to Sharepoint and extract a list. I connect with a Microsoft account. When I publish to the server I need to configure the da...
asked by 19.11.2018 / 16:29