Category "powerbi"

How can I add a column with find the closest date found in a second table using dax or m?

I have two tables. One with dates of tech support given, and the other one with surveys sent to the customers. The problem is that the surveys are sent some day

Sort column circular dependency in Power BI

I have to sort month name from January to December in Power BI Desktop. Power BI sorts the column according to the alphabetical order. Here is my dataset: When

Power BI : filter on a rank

I have calculated ranked using this formula which worked perfectly well : RANK = RANKX(ALL(td_store[LIB_MAG]), CALCULATE(SUM(tf_market_share_by_store_nomcenclat

How can I get total amount value for each different user in PowerBI

I want sum all 308 values in userprofileid column to get the total amount of the values for that user in the amount column This image shows GROUPBY(userprofile

PowerBI - getting EmbedToken - Unauthorized

I have been trying WITH NO LUCK, to get an embed token to be able to embed my powerbi reports into my existing .netcore web api application. The front end look

Get the max date value for each user in PowerBI

I can't get the MAX date value for each user in PowerBI. For example, in this image for userprofile 170 I want 09/12/2020 value because is the maximum value fo

How to count rows in a table, where a specific column value is in a list of specified values?

How do I create a DAX measure to count the number of customers in a customer table dCustomers, where the customerType is either FR, DE or GG? In SQL, this would

what kind of measure or column will use here

[Please refer to the below image. I want to create a stacked column chart but I don't have a column that includes 0-30, 30-60, 60-90, etc. How did I put this ra

Can we export PDF and PPT of an embedded Power BI report by calling an the Export feature of the Power BI Service/Workspace

We have an embedded Power BI Report and we wish to have an export functionality in the website which calls the export option that is present in the top bar in t

Pywinauto - There are 2 elements that match criteria

this is my first post! I would like to ask you how can i solve this problem. I am trying to automate publish in powerBI. I need to click on correct workspace. R

How convert "blank" to 0 in a card in Power BI with live connection with analysis services?

i have a dashboard in power bi that take data from analysis services. The problem is that can't show a 0 in a card when there aren't values for this filter. in

Is there a way to direct query Salesforce Objects to Power Query/Power BI without having to extract the object

My data lives in Salesforce objects and I am trying to connect Power Query to Salesforce Objects. The limitation here is that I have to extract the whole object

How to extend powerBI token Id expiry time

How do I change the token Expiry time in power Bi? Steps followed to generate token: Registered power Bi App After providing the details got the client id and

Power BI: Plot not showing complete data

I am using a ribbon chart to visualise total sales over 3 years, using Product ID as legend. Then in another bar graph I plotted total sales by Product ID. What

How to disable visual from being selected but show tooltip on mouseover?

I have a table and a chart visual. When user clicks on table cell or bar chart, the other visuals get filtered/highlighted. I know this can be disabled using th

Embedding paginated report in Power BI Embedded Gen 2 - web application

I have a power bi paginated report which is published in the workspace, powered by a A2 SKU (power BI embedded gen2) so the paginated report workload is already

Strange issue in SSRS 2016. I am unable to select parameters or run the report intermittently, it works fine most of the time

I am having a strange issue with SSRS 2016. We setup a new server and uploaded some reports, the reports ran fine for few days. The issue is, randomly the repor

Dataframe Column name not defined PowerBI Python Integration

i wrote code to visualize matplotlib bar chart using the python Jupiter notebook. But now I wanted to integrate that code with powerBI. That dataset includes 3

Power BI - Data Load Error- OLE DB or ODBC error: [DataSource.Error] PostgreSQL: Exception while reading from stream

My question might look similar to some earlier posts but none of the solution has answered what is the rootcause of this behavior. I would try to explain what I

Group by columns on Power BI

I have column in which 3-4 different values and data like this companyname servicestatus employee abc inservice abc_e1 abc inserv