Stack Overflow
Stack Overflow

Questions tagged [powerbi-datasource]

622 questions
2
votes
1 answer

Default Date on Slicer & custom selection

I have a date slicer which should show last 12 days as selected when report opens. Further, user should have flexibility to select any other date range. enter image description here
suresh ramesh
  • 21
  • 2
2
votes
1 answer

Automatic hourly refresh of a Power BI dataset from an Excel file stored on OneDrive

How to set up automatic hourly refresh of a Power BI dataset from an Excel file stored on OneDrive for Business? What am I doing wrong? My set up goes the following path on the map of possible connections described by Vesa Tikkanen in the post Power…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
2
votes
1 answer

Need If formula to apply in Power bi dax for a report

I have a report in excel as shown in table where there are 7 columns. "Backlog" column is calculated column, in which, I have applied formula in Row1 of Backlog col. =IFERROR( IF( Month End="Y", ((IFERROR(IF(01/2020=Report…
Kiran Patel
  • 65
  • 1
  • 7
2
votes
2 answers

Subtracting values from the same column but different rows in power bi

I'm calculating the difference of "closed column". All data is in one column and I'm calculating the difference between Row2-Row1 for all the rows. I'm getting results as some positive values and some negative. Positive values are coming correct but…
Kiran Patel
  • 65
  • 1
  • 7
2
votes
1 answer

Power BI calculate percentage (divide) using Filter

I need to show percentage in gauge chart something like this I am able to bring 3000 and 37% is the something that needs to be calculated. This guage charts need to show that the data you are looking for/filtering holds 37% of 3000 (i.e. 1110) Now…
xorpower
  • 17,975
  • 51
  • 129
  • 180
2
votes
1 answer

Power BI - Create Datasource Endpoint Error

I'm trying to use the Create Datasource REST endpoint from Microsoft's Power BI API, but I'm getting a 400 error when I send the encrypted string of my Windows credentials. My API is written in nodejs, so I'm using node-rsa to replicate the…
ohcalcutta
  • 21
  • 1
2
votes
2 answers

Get a count of a particular column, based on another column of the same table - Power BI

I have two tables. Table A and Table B. The relationship from Table A to Table B is one to many. One Table A record gives me several Table B records. Table A contains my master data and Table B contains additional data. Here is what the two tables…
nopassport1
  • 1,821
  • 1
  • 25
  • 53
2
votes
1 answer

How to subtract Yesterday count by today count group by id in power bi?

I'm trying to subtract the Yesterday Count by today count using startDate and group by id. Expected result is id startDate count newColumn xyz Yesterday date 46 40(yesterday-today) xyz Today date 6 today-nextday
KARTHIKEYAN.A
  • 18,210
  • 6
  • 124
  • 133
2
votes
1 answer

How to specify whether EffectiveIdentity is required in PowerBI

I'm embedding a Power BI report in a web page, using the AppOwnsData sample as a base. Everything is working fine, using the Service Principal for authentication. However, now I'd like to pass through an "Effective Identity". When I initially try…
Paul Michaels
  • 16,185
  • 43
  • 146
  • 269
2
votes
2 answers

Making a POST REST API call in Power Bi Query Functions to generate a token, and used that JWT based token to make another GET API Call

I have requirement to make a POST REST API call using Power Bi Query Functions to get the JWT access token. Then use the same token obtained make a GET API call to obtain data that has to be displayed in a Power Bi Dashboard. Now the issue is, I am…
Aditya Bhattacharya
  • 914
  • 2
  • 9
  • 22
2
votes
1 answer

How do I change the server of a Power BI gateway after dozens of reports have been pointed to it?

We are currently using an on-premises data gateway to allow our reports in the app.powerBI.com web interface use an on-premise SQL Server Analysis Services (SSAS) server tabular model for their data source. Dozens of reports, workspaces, and other…
kscott
  • 1,866
  • 3
  • 25
  • 41
2
votes
2 answers

Power BI API POST datasource errors with DMTS_InvalidEncryptionAlgorithmError

I am trying to use the Microsoft Power BI API to create a new data source on a gateway https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/createdatasource. To test I am trying to create a connection to an Azure Sql Database with basic…
tim
  • 358
  • 3
  • 14
2
votes
1 answer

SSAS Tabular Model - Dealing with date and 30 minute time interval

I've created an SSAS Tabular Model in which I have two different tables, AGENT and CHAT, that I would like to be related in order to filter and group by DATE and a 30 minute time interval field called INTERVAL in a Power BI report hierarchy. Both…
Cassandra Pratt
  • 73
  • 7
2
votes
1 answer

Power BI - how to get reports on Power BI web on the basis of parameters

I am new to Power BI, doing some work. I have millions of records in SQL Server database, what i want to achieve is.. whenever my colleagues open the report on Power BI, it must ask for the date parameter. Once the date is submitted, then it must go…
Quentin
  • 45
  • 1
  • 5
2
votes
1 answer

How to get power bi dashboard in our own application?

I am new to power bi. I have power bi account there I created some dashboards with some reports, now I want to consume those dashboard and report using power bi rest API (https://learn.microsoft.com/en-us/rest/api/power-bi/)in our own application.…
Sagar Patil
  • 469
  • 9
  • 20
1 2 3
…
41 42