Questions tagged as 'powerbi'

Tagged questions
0
answers

Changing parameters in power bi

Good morning, I'm starting now in Power BI and I'm trying to make two sql queries swap parameters. At first query I have a query sql returns the project code and the name of it. In the second query I have the following proc (exec [dbo]....
asked by 07.11.2018 / 13:36
0
answers

How to unify powerbi files - pbix

Is it possible to merge two separate pbix reports into 1 only? with all imported tables and measures created? if it is possible, how to do it? I need to unify two PowerBi reports and I would like a way to "import" the measures already created...
asked by 08.11.2018 / 13:36
0
answers

Get last value by data power bi

I'm trying to fit a DAX function to get the last value of a column from a Sales table based on the product code and a price table code. For example I have a product that throughout the year had 3 prices in the same sales table at 022 for exam...
asked by 22.10.2018 / 19:27
0
answers

Power Bi and Interbase

I'm trying to get data using the Power BI desktop from an Interbase database. Power BI does not have a * "native connection" * to Interbase, as it does to SQL Server databases. I added the Interbase ODBC driver to the DSN and made the basi...
asked by 14.08.2018 / 02:35
1
answer

Power BI - Oracle SQL Query

Hello, I'm trying to get data in Power BI via Query in an Oracle DB and is experiencing the following error. Unable to establish connection Details: "Oracle: ORA-01843: not a valid month" SELECT DISTINCT J.JOBID, J.JOBNAME, --J.FOLDER...
asked by 05.08.2018 / 20:22
0
answers

How to resolve duplicate data in Power BI?

I ended up inserting the same access data file twice into Power BI, how do I ignore one of them, and show the correct value instead of duplicate in the table and graph?     
asked by 23.07.2018 / 20:22
0
answers

Power BI - Problem connecting to Analysis Services

I'm trying to connect Power BI with Analysis Services, but I can not. Being that through Excel I can connect. At the time of putting the IP of the server, I tried two ways: XXX.XXX.XXX.XXX or, as in connection to SQL Server, XXX.XXX.XXX.XXX:1433...
asked by 12.06.2018 / 15:34
0
answers

Error - Power BI connection with SQL Server

I'm trying to connect power bi with my sql server database, however, the error below is occurring. NOTE: TCP / IP and Name Piper are enabled on the SQL server. These were the database connection data. Server: 122.122.122.122 \ MSSQLS...
asked by 01.06.2018 / 14:15
0
answers

Completing information in the Power BI table

I was hoping someone could help me with a piece of the formula to get me to my ultimate goal. PR_HIST_MOVIM_PEDID table LOGTable PR_HIST_MOVIM_PEDIDtablehasorderstatusbyday,butwhenyouturnthemonth,itlosesinformation.ALOGtablehasonelasttransit...
asked by 27.04.2018 / 14:32
1
answer

Displaying specific values in DAX and POwer BI

Good morning staff I just want to display in a card report, the amount of the final cash balance of the day, according to the filter per day that I already have mounted: Final cash balance is not a calculated column, it is already im...
asked by 17.04.2018 / 14:15