Questions tagged [powerbi]

1

votes
2

answer
320

Views

How to display custom values between date intervals using Dax in Power BI

I am trying to display custom values between different dates using the following formula in DAX (power Bi) = if ([RegistrationDate] >= '6/14/2018' & [RegistrationDate] = '7/16/2018' & [RegistrationDate] = '8/27/2018' then 'M6' else '' Basically the logic behind it is: If the range column contains da...
Adi Petrescu
1

votes
2

answer
491

Views

Calculated Column to get average from values in another table in PowerBI

This might be very basic but I am new to PowerBI. How do I get average of values for unique ID into another table. For eg. My Table 1 has multiple ID values. I have created another table for unique ID which I am planning to used to join other table. I want a calculated column in table 2 which will g...
Neil S
1

votes
2

answer
78

Views

Inactive relationships affecting measures

I have the following tables & relationships in our pbix report: For some obvious reasons, I need to have a relationship (non-active) between Dates[date] and Table2[T2Date]. However, doing so causes data fluctuation to measure 'Total Amount' in Table1. Here are some screenshots: Before Relationshi...
Pratik Bhavsar
0

votes
0

answer
8

Views

Power BI sorting irrespective of number

I have one Power BI report that has bar graph in it. I need sorting to work out irrespective of the value that it is bringing in. For example, see the sample dashboard: The dashboard shows immigration population of certain countries from 1920-2010. There are few countries displaying negative values....
Romil N
1

votes
1

answer
48

Views

Translate select query to DAX expression

Im trying to convert some SQL queries to DAX, but I dont know where to start. SELECT jobid,Fullname FROM public.'Data' WHERE jobid IN ( SELECT jobid FROM public.'Data' GROUP BY jobid HAVING max(case when Userid = '21' then 1 else 0 end) = 0) ORDER BY jobid ASC; The data looks like this: I want th...
nick bijmoer
0

votes
0

answer
4

Views

How to Filter table and Limit it to 1 TOP row with Dax

I'm new to Powr BI and Dax queries. I have 2 tables added with 1:* relation. What I'm trying to do is to filter the second table by a foreign key and specific Key. Ex. ###Table1:### ID | RunID | ...[Other columns] ###Table2:### ID | RunID | Key | Value | State So what I'm trying to do in Power BI...
Alex K.
0

votes
0

answer
2

Views

ExpandRecordColumn dynamic column list based on field value

Is is possible to ExpandRecordColumn and use the value of a different field to determine the column list? [Greatly simplified] data set (field value) looks like this from a web API: { sprints: [{ id: 616, name: 'S1' }, { id: 615, name: 'S2' }, { id: 625, name: 'S3' }], velocityStatEntries: { 615: {...
ktharsis
1

votes
0

answer
389

Views

Power BI -spark -ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (4)

I am connecting spark sql to power BI but getting error : Details: 'ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (4) Error occurred while contacting server: SSL_read: error code: 0. The connection has been configured to not use SASL for authentication. This error might be due to the server has...
mahendra maid
1

votes
1

answer
278

Views

Azure access token always returns 401

I have obtained an access token from https://login.microsoftonline.com/tenentid/oauth2/token - using the grant_type=client_credentials Now, when I try to get the embedded token from https://api.powerbi.com/v1.0/myorg/groups/gid/reports/rid/GenerateToken it always returns 401 unauthorized. Does anyon...
Sandeep Dhankhar
1

votes
1

answer
224

Views

Calculate performance vs LY with shifting month dates

I've tried so many times to solve this, but failed. Question: I help on a solution on how to calculate Current Year divided by last year in our Fiscal Year, month by month, where last years date differs from this years date Scenario I want to see how we performed on revenue January 2017 vs. Januar...
Dendera
1

votes
1

answer
421

Views

SamePeriodLastYear by Day

I am looking to calculate the sales for the SAMEPERIODLASTYEAR. I have a table which looks at the sales for the last few years and using the SAMEPERIODLASTYEAR function I can draw back to last January as a whole, but what I am wanting is to pull it to the date exactly and not to the end of the curre...
MBrann
1

votes
0

answer
170

Views

Access data source thru Power BI gateway

We have a need of accessing a data source from Power BI service using the push data set mechanism. As the data source resides on a private network, the idea is to set up a Power BI gateway providing us direct access without opening up the network firewall. Now, we see that the PBI gateway offers a...
Jerry Karlsson
1

votes
2

answer
608

Views

Power BI - How to show next 2 days of selected date?

I'm new to Power BI and I am having difficulties. I have some slicers as filters and two chart as below: Sample Report The bottom chart shows data with data according to date selected in the slicers which is straight forward. E.g. The slicer selected 15-Oct-2017, the bottom chart should shows 15-Oct...
likuku
1

votes
1

answer
292

Views

Custom PowerBI Data Connector Crypto.CreateHash Won't Accept SHA1

I'm trying to create a custom data connector for PowerBI. I need to create an SHA1 hash for an authentication process. Here is the code that I am currently using let nonce = Text.NewGuid(), timestamp = DateTimeZone.ToText(DateTimeZone.UtcNow()), digestBin = Crypto.CreateHash(CryptoAlgorithm.SHA1, T...
DJ Sitte
1

votes
2

answer
208

Views

OAuth token state and invalidate

Given I have acquired an OAuth2 token from https://login.windows.net/{tenant-id}/oauth2/token using the password grant type, is their a REST API to get the status of that token invalidate the token (logout) I will be using this token to access Power BI REST APIs
Johno
1

votes
0

answer
30

Views

No Authorisation REST API after Publish Header

I have designed a dashboard within Power BI Desktop using our own data. This data is accessed using a REST API which is authorized using a token in the header. Everything works fine, but then I publish to Power BI Services and want to schedule the refresh. It shows a 400 error. It seems to be that t...
Menno Veen
1

votes
0

answer
206

Views

ESRI color gradient map theme in Power BI

Heat maps in Power BI are based on distance. What I would like is a color gradient (i.e. a smooth color transition from one color to the other) between points of different color. Here are some examples of wind potential energy and biodiversity possibly made is similar ways: The algorithm that calcu...
Davor Josipovic
1

votes
2

answer
390

Views

Including Re-occurring Time Saved in Date Slicer Output

I am looking into utilising PowerBI to identify time saved due to various Projects. People will add the projects to a Sharepoint List which then feeds into PowerBI. PROJECTs Table: Project Tite, Desc, Hours/Month Saved, StartDate, EndDate, Repeat? (T/F) [Some Projects only save a fixed 10 or so hour...
Kieran Lane
1

votes
2

answer
52

Views

Slideshow created using Jquery stops working after rotating for 4 times

I'm using this jquery code to cycle through some power bi slides on a loop. Now we had a request to create a image slideshow as well. The logic behind the code is that the powerbi slides will run, then 3 images will be selected randomnly and this process will go on and on, on a continous loop. I've...
Joe Miranda
1

votes
2

answer
442

Views

How can I get a value from a nested table in Power M Code

I would like to get the Max value for [GroupIndex] and then use it to divide [Monthly Target] in order to create [Target]. The issue is I don't know how to get a single value from a nested table. This is what I've tried so far: Use Table.RowCount() like this: =Table.TransformColumns(Test, {'Count',...
virtualdvid
1

votes
1

answer
99

Views

Filter and sum a second colunmn by filter context

I have a table with a CompanyID, PartnerCompanyID and Sales. If the customer is a group partner company, a further PartnerCompanyID column is filled with the CompanyID of the internal customer. I’d like to sum the sales but only for sales other than internal sales between the companies within the...
A. Golenko
1

votes
0

answer
73

Views

Library (rChart) and internal widget saving in power bi custom visual

I am creating a custom visual for power bi using rcharts but when it goes for saving the widget it say returns me an error. This is my code: source('./r_files/flatten_HTML.r') libraryRequireInstall('plotly') library(rCharts) library(fmsb) library(plyr) library(dplyr) library(reshape2) library(RColo...
Johny Donica
1

votes
0

answer
605

Views

SQL query to DAX in Power BI

I have the following SQL Query: SELECT * FROM [table1] INNER JOIN (SELECT [table2].table1_id, [table4].table4_id, count(*) FROM [table2] INNER JOIN [table3] ON [table2].table3_id = [table3].table3_id INNER JOIN [table4] ON [table4].table4_id = [table3].table4_id GROUP BY [table2].table1_id) as ON...
Matías Gaete
1

votes
0

answer
591

Views

Show last 12 months of data on a bar chart according to the slicer choice

my issue is as below: I hava a Calendar table with dates and Orders Table related to the Calendar table by DateID. I have slicer that allows user to choose month and year from a Calendar table so that the data will be shown only for the choosen month but on one bar chart i would like to show sum of...
nothingman
1

votes
0

answer
164

Views

Power BI refresh: organizational account refresh

I have a Power BI report which pulls data from a SharePoint 2013 (on premise) list. The SharePoint belongs to a different organization so the report uses organizational account to read the list via oData source. The report works fine locally. The problem is when we publish the report to Power BI ser...
cqi
1

votes
1

answer
764

Views

How do you get a custom PowerQuery function that returns a one cell Table to return text instead

I'm trying to teach myself to write PowerQuery M functions by scraping suggestions listed at the PowerBI Ideas website. I come from a VBA background, so M is quite foreign to me. I've got a function that creates a dynamic URL given a Category_ID and PageNumber that I feed to it. I have another coup...
jeffreyweir
1

votes
1

answer
411

Views

Power BI embed code throws 403 forbidden error from server. How to fix this?

The embedded power BI dashboard is displaying in my sub-domain 'a.mydomain.com' and in my localhost. But it's not displaying in my another sub-domain 'b.mydomain.com'. FYI I'm embedding the powerBI via javascript and JWT encoded token. In 'b.mydomain.com', the js code when trying to access report vi...
John Babu
1

votes
1

answer
317

Views

POST JSON data to power bi api 404 ERROR

I'm pushing a csv, converted to a JSON file, to my power bi api. Each individual column is shown correctly on power bi, however, when confronting the code with adding rows to the column, I receive a 404 error: Succes: 200 Succes: 200 response status dataset: 201 dataset responses: 200 response...
R A
1

votes
3

answer
157

Views

Power BI Nesting Hierarchy Indicator to Match Power Pivot

I have a client that is accustomed to seeing hierarchy nesting in Power Pivot using Excel that looks and behaves like this: [ Specifically, they love the plus/minus expand/collapse functionality. We are now moving to Power BI which has a different philosophy when it comes to navigating a hierarchy....
Doug
1

votes
1

answer
1.3k

Views

Options for accessing SSRS reports through Power BI Service

I have a number of reports I have deployed to an SSRS report server in my intranet. The reports display data in tables & a matrix with some other summary information in the report header and footer. The report data source is SQL Server 2014. I now have a requirement to have these reports accessible...
StackTrace
1

votes
1

answer
160

Views

MAXX function not working properly

I earlier put this question on the SharePoint StackExchange site but it was considered off-topic. Hoping for better luck here. I have a problem with the DAX MAXX function (with a FILTER), used in my Power BI. It works only sometimes and 'partially' in very confusing ways. I am following this tutoria...
Perry J
1

votes
0

answer
534

Views

PowerBI: Date and Date time Filter Using URL Parameter in report

I am Using power bi online for using date and DateTime slicer in the report. when I'm using slicer than the powerbi slicer will be working fine. but when the same thing will using via passing the query in URL URL?filter=Table/Date eq '2018-02-19 14:48:35.020' then it will not be working. please sugg...
Rahul Dhoundiyal
1

votes
1

answer
186

Views

How to use extended @types in project based on internal modules

I am in need for some guidance to do something that is kinda basic when not using namespaces. I am using in this case leaflet (javascript lib for maps) and leaflet.heat (leaflet plugin to make heatmaps). Without messing with namespaces/modules, importing them would be just something like it's pointe...
alrodseg
1

votes
0

answer
360

Views

Power BI Embedded Token Not allowing me to get report by id

I'm trying to use the Power BI API to load a Power BI Embedded report into my custom web app. I login against AD And then use that token to access the report list using https://api.powerbi.com/v1.0/myorg/groups/{{groupId}}/reports Then use the report ID selected to generate a token and then request...
NathofGod
1

votes
0

answer
290

Views

display monkey with power bi

we like to use Display Monkey (www.displaymonkey.org) to show power bi pages on digital signage monitors. To do that we have to add a new app to our azure portal and then we have to setup a new azure account in Display Monkey, but we always get the message that our windows credentials are not valid...
DeeFour
1

votes
1

answer
123

Views

PowerBi: Measure over ID

I have a table with: ID, delta & Date I added a calculated column: SD = CALCULATE(STDEV.P(Query1[delta]),FILTER(Query1,Query1[sys_id] = EARLIER(Query1[sys_id]))) Calculating the standard deviation of delta... for each id. What I want to do now is that when I have a filter (slicer) on the date colu...
Dextrious
1

votes
1

answer
24

Views

Country is selected as “All” calculate a specific column value only

Need some advise on how to filter data when in 'Country' column is selected as 'All' then consider only specific value which is in different column(Raw) else calculate respective values(column Coverage) for respective Countries There are 3 columns - Country, Coverage and Raw Basically when selected...
3689
1

votes
1

answer
454

Views

Power BI: Opportunity model (relating 3 tables)

I'm trying to create an 'opportunity' calculation model, but the output results that I'm getting are not accurate. Sample problem would be McDonald's and Burger King who sell food in various regions, some regions have both BK and McD in the area and they both sell similar food types, but some have b...
haosmark
1

votes
2

answer
534

Views

Error with Power Bi Embed Filter Settings

So I have the embed working in Power Bi based on this model [https://community.powerbi.com/t5/Developer/Embedded-Report-add-filter-to-EmbedConfig/td-p/199739] But things start failing once I add in the filter. Its throwing an error in including settings in the config. I'm following the model outline...
Vandelay Web
1

votes
1

answer
3.3k

Views

How do you create a calculated cumulative total value column in a power bi matrix visualization?

I am pretty new to Power BI, but I'm learning alot fast. I do have one challenge at this point that has me stumped and I'm really not finding anything online that relates very closely. I have created a basic matrix visualization that gives me sales totals by UPC code. The UPC code is in the Rows and...
Todd Brannon

View additional questions