Questions tagged [powerbi]

Power BI is a free, self-service analytics tool available individually or integrated with Microsoft Excel, Office 365 and all major Databases and analytics tools.

0
votes
0answers
5 views

Row level security in Power Bi

I am not able to implement row level security to my report. I have tried different methods on google and Microsoft forums but all in vain. Could you please help? I have a dataset name "Cases" which ...
0
votes
0answers
5 views

HTTP 401 Unauthorized when export report by using PowerBi rest api

I got 401 unauthorized when trying to export report form powerbi online by using powerbi rest api. My access token work fine with other api method, im also setting full api access in App ...
0
votes
0answers
3 views

Mapping Data from a datasource to a customized entity in Power BI Service

I've been working with Power BI Service and Common Model Data. I created a Azure Data Lake Storage Gen 2 and I am getting data from different data sources such Excel, ERP systems, Azure Databases, ...
0
votes
0answers
8 views

Calculation Error: A table of multiple values was supplied where a single value was expected

I want to show this year store count based on to date and from date.The following code is throwing this error when i am placing this column in table. ThisYearStoreCount = IF ( [DateDiff] > 365,...
0
votes
0answers
6 views

Calculated column based on a disconnected slicer

I'm not sure I've summarised this question correctly, so I'll add a description below of the actual problem. We have a report that displays data for 'jobs'. These jobs have a few relevant date fields ...
0
votes
1answer
15 views

Power Bi Desktop - How to add values between tables?

I'm trying to create a column that has a total of values between 3 columns from 3 tables. How would I go about doing this? The 2 tables are tables of values that share an id, and they are both linked ...
0
votes
0answers
10 views

Can not find a kpi productivity report

From this moment I have about 24 hours to complete my bachelor thesis "Analysis of Labor Productivity through Business Intelligence Tool". I have desperately searched for company productivity reports, ...
1
vote
0answers
18 views

error trying to embed power bi in reactjs app

I'm trying to show a power bi report on a website using reactjs, and through a form I want to filter the information i have done the part of handle form data, but when i try to filter my power bi ...
0
votes
1answer
11 views

Refreshing data automatically in Power BI Desktop

I am using the free version of Power BI Desktop (I am new, this is the first time I use it). I have a dashboard which has many tabs. I have configured SQL Server Database to be the source of the data ...
1
vote
1answer
35 views

Change version of Python via Anaconda Prompt

I am trying to download python for a colleague via Anaconda. We are trying to download the right version as to maintain compatibility with Power BI. We're looking to implement Python visuals from ...
0
votes
1answer
18 views

Calculate Column Sum of a Generated Table - DAX

I've been trying to get the sum of the following table's column VALUE using DaxStudio in order to put that on PowerBI once is's ok, since PBI can get slow if you test a code for large calculated ...
1
vote
1answer
20 views

How to multiply measures across dimension in Power BI tables?

I have a complete report in Excel and now I'm trying to replicate it in Power BI. Now I have some issues regarding calculation. Since it's not possible to use cell references in PBI and the concept is ...
0
votes
1answer
21 views

Dynamic Columns Selection in SUMMARIZECOLUMNS

I want to dynamically select columns in summarizecolumns based on a condition: EVALUATE SUMMARIZECOLUMNS( IF( True(), Date[Year], Date[FiscalYear]), "Reference Date", STARTOFMONTH(Date[Date]) ...
0
votes
0answers
14 views

PowerBI Linear Regression line does not match R2 calculation

I have the following data: It looks like the R2 should be pretty high in this example! However, R is 0.06 and R2 is 0. For these calculations I used the build in functions of PowerBI for R and R2. ...
0
votes
1answer
28 views

How to pass dynamic parametrs to query in MS Power BI?

I need to build a report in Power BI. I can get the data for the report by calling the MS SQL Server stored procedure with parameters. Question: How can I pass dynamic parameters from a report to a ...
0
votes
0answers
12 views

Need documentation for *.analysis.windows.net/public/reports/querydata

I am reverse engineering an app that sends queries to SOMESERVERNAME.analysis.windows.net/public/reports/querydata via an HTTP POST of an JSON-structured query. Some initial lines of a sample query ...
0
votes
0answers
9 views

powerbi custom visualisation develop

I want to embed HTML page in Power BI custom visual, but I don't know how to get the selected page filter value in Update function. public update(options: VisualUpdateOptions) { this....
0
votes
1answer
29 views

Top value by criteria and order

I'm trying to calculate the maximum value with multiple conditions and order in Power BI. I've called the function to create a column with the top1 by Year, Branch, Group and Type disconsidering ...
0
votes
0answers
16 views

Power BI : Matrix Get the difference of two columns

I am trying to figure out how to get the difference of two columns within a row in Matrix everything that was available in the community has been hardcoding the values of the column label. I would ...
1
vote
1answer
24 views

I want a measure to avoid being filtered by a bar chat axis

I have a bar chart with a variable "MBA Type" in the axis. "MBA Type" is a categorical variable with the following possible successive values: {MBA-LB, MBA1, MBA2, EMAP} Values are calculated from ...
1
vote
1answer
29 views

An Argument of Function Date has wrong data type or result is too small or too large Error

Getting the error An Argument of Function Date has wrong data type or result is too small or too large when the following measure is included in any graph. However, the Value is shown properly in ...
0
votes
1answer
15 views

PowerBI M: How to code in an exclusion to an IF statement

I'm working to programmatically clean up a field in my dataset by using a Helper column that I will later filter on and remove the 'junk' records. The junk records are ID's, and the valid records are ...
1
vote
1answer
27 views

POWER BI - Maximum value with if condition

I'm trying to calculate the maximum value with multiple conditions in Power BI. The dataframe is: Year Company Bond Branch Group Type Value 2016 BANCO DO BRASIL ...
1
vote
1answer
36 views

Count if <= row by row calculation

I am trying to count the number of results that are <= 25%. See bellow for example data I am trying to create a measure that counts if "Pallet Utilization" is <= 25%. "Pallet Utilization" is ...
2
votes
0answers
27 views

Cannot write csv file on a secured OneDrive folder using R script in Power BI without OneDrive API

I'm writing a script in Power BI Service using R that will automatically download a specific dataset into a file on OneDrive. However, I keep getting this error: can only open URLs for ...
0
votes
1answer
25 views

DAX studio showing additional (duplicate) local tables

My power Bi model contains the following tables: However, when I connect to this model from DAX studio, I get the following: Please note that all of these local date tables show the same metadata ...
0
votes
0answers
26 views

Display dynamic content of a webpage using R in Power BI

I have a website which has dynamic content in it. I want to display the website in Power BI using R Script visual. Before trying it in Power BI, i want to try this in R Studio. For that i tried below ...
-3
votes
1answer
17 views

Sorting the Timeline chart from POWER BI

i have a data where its Financial year is started from July and ends with June What I need is I want to arrange the Month in that order like July -Aug------ Jan-Feb------ June I'm tired of ...
2
votes
1answer
56 views

Can a measure be created in Power BI that references two tables that share no relationship?

I'm trying to create a matrix table in Power BI to display the monthly rent projections for a number of properties. I thought I could simply create a measure that summed the rent from one table and ...
1
vote
1answer
38 views

Relationship with Date table with multiple fields

I need to link Dates Tables with multiple fields from different tables that also must be linked between each other. 3 data sources: Milestones (has Project ID - unique values) Report - Benefits (...
0
votes
2answers
53 views

Is there a faster/more efficient alternative for finding a value's closest match from a list in M/PowerQuery other than recursion?

first post on Stack Overflow. I'm trying to get some perspective on finding closest matched values from lists and table columns using Power Query. So if you have a list of {1.1, 3.2, 4.5, 6.6, 7.8} ...
0
votes
2answers
29 views

Power BI Count Number of Rows Below Median Score

I have one column with scores and need to calculate the count of rows at or below the median score of the column. I tried the below formula but it appears I'm not allowed to use Median as a filter ...
1
vote
2answers
40 views

Calculate latest date for every ID with DAX

I have a dataset in Power BI like this: ID FirstDate LastDate 214443 07/06/2016 07/06/2017 214443 09/11/2016 09/11/2017 214443 28/09/2018 11/06/2019 214443 31/05/2019 11/06/2019 I ...
-1
votes
0answers
20 views

Best reporting tool for real time data visualization [on hold]

I know I’m asking a much generalized question: I was going through similar like this : https://social.msdn.microsoft.com/Forums/sqlserver/en-US/44094120-beb7-4f8e-bb58-c0d5b5a356e1/real-time-...
0
votes
1answer
23 views

How to calculate average using inactive relationship and SUMMARIZE function in Power BI

I have inactive relationship from dim_Date[Date] to fact_Loss[DateClosed] . I need to calculate an average monthly number of Closed Claims by DateClosed. I was able to calculate monthly ...
-1
votes
0answers
43 views

Power BI - SQL Server Merge Multiple Rows Into One

We are trying to put together a report in Power BI Desktop using data from SQL Server, we are having issues with duplicate values. The above screenshot shows the problem, we have a job with the same ...
-2
votes
1answer
85 views

How to integrate Power BI in a Delphi desktop application

Has anyone integrated Microsoft Power BI into a Delphi application. I beleive that I will need to embed a webpage into a form,I am ok with that, however I cant see how you force a refresh or feed ...
0
votes
1answer
18 views

Trying to convert year quarter 2Q03 format column values to date in Power Bi

I am a newbie to power BI and trying to convert Year Quarter column which is in 2Q03 to either 30/06/2003 or 2003 Q2. Much appreciated for the help in advacne.
1
vote
0answers
13 views

Using Kerberos request type instead of NTLM in power-bi report server

I'm having a server with power-bi reporting service installed and configured on it, and from my front-end that hosts the application, i've got angular 7 with proper power-bi components installed. ...
0
votes
0answers
21 views

How can I Optimize my slow running Power BI Report which have number of Visuals and DAX Measures

My Power BI Report is very slow. It has 250 DAX Measures and 32 Visuals. When I running DAX studio, it's showing 104 DAX Query running on back-end. And, these Visuals and DAX Measures are the very ...
0
votes
1answer
28 views

How to calculate ratios for each category in PowerBI?

I have data that looks like this Category Outcome -------- ------- A Pass B Pass A Pass A Fail B Fail A Unknown B ...
0
votes
0answers
14 views

How to get spillover PBI's in VSTS using power bi

In VSTS the spillover PBI'S also displayed in earlier sprint from where the PBI got the spillover but when i am trying to fetch the data from previous sprint using power bi i am not getting spillover ...
1
vote
1answer
31 views

Convert Numeric type 2000.50 to 2000/09/30 data format in powerbi

I'm trying to convert numeric column which have values as 2000.50/2000.75 and to date format as 2000/09/30 in PowerBI VAR FiscalYear2 = LEFT ( Axio_QuarterlySupplyDemandModelNational[Year_Dup], ...
2
votes
0answers
47 views

PowerBI: how do you calculate the difference between two columns in matrix

I have a matrix defined as the values : I wanted to run a difference between the values that is seen on each date from Baseline and Scenario1 (it can be more than 2) So the columns are defined as : ...
0
votes
0answers
13 views

Excel/Power BI: How do we compare columns from a pivot table

I a pivot table that contains 2 different scenarios for the same data: What I am trying to do is be able to comapre each value in each column based on the row key values so that I can present the ...
0
votes
0answers
29 views

How do you use analytics with Odata on azureDevOps to query test results and which suite it belongs to

Due to limitations with creating dashboards in AzureDevOps for Test data, I am trying to use the analytics odata to query test results data. The issue I am having is creating a single query to have ...
0
votes
1answer
15 views

Previous month categorical value Power BI

I have the table which looks something like this. I am trying to find a way to find status change per an account, e.g. if the current month the status is Written off but it was Active last month, the ...
0
votes
1answer
42 views

Replicating Excel averageifs in PowerBI

I'm having difficulty replicating the following Excel calculation in power BI =IFERROR(AVERAGEIFS(Data!$I:$I,Data!$A:$A,Tables!$C$2,Data!$B:$B,Tables!$E$2,Data!$E:$E,Tables!$B5), "N/A") I am trying ...
1
vote
1answer
47 views

Running total based on other columns value

I need to calculate running total of forecast amount starting from maximum value, based on two stock locations and once for each product (product numbers are repetitive due to stock locations). e.g ...
0
votes
1answer
43 views

PowerBI running Total formula

I have a dataset OvertimeHours with EMPLID, checkdate and NumberOfHours (and other fields). I need a running total NumberOfHours for each employee by checkdate. I tried using the Quick Measure ...