Stack Overflow
Stack Overflow

Questions tagged [powerbi]

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

Power BI is a cloud-focused data integration, and visualization service that gives you a single view of your data. Dashboards, reports, and datasets are the core functional objects in Power BI.

The main components of Power BI are Power BI Desktop and the Power BI Web Service. Power BI Desktop is a design tool for integrating datasets and visualizing them in reports, while Power BI Web Service focuses on sharing the reports and dashboards with users so that they can be viewed and interacted with.

Power BI also has a range of APIs for programmatic access to the Power BI Web Service.

Power BI Desktop is available as a free download from Microsoft.

For documentation, please see white papers.

18477 questions
2
votes
2 answers

Power BI Desktop Import data limitation

When I use Power BI Import (Connect to SQL Server and select Import) to get data to Power BI Desktop, is there a data volume limitation? I know for DirectQuery there is no data volume limitation. What about Import? Is it 1GB?
Thilok Gunawardena
  • 924
  • 5
  • 22
  • 44
2
votes
1 answer

How to conditionally format color based on a categorical value?

I am creating table visualizations in Power BI. I know how to use conditional formatting to automatically set colors based on numerical values, but I want to color the rows of my visualization based on a categorical variable. In my table there is a…
indigochild
  • 350
  • 1
  • 5
  • 21
2
votes
3 answers

Export million rows table from Power BI overcome the limit of 150k rows

Is there a way to overcome the Power BI export max limit of 150k rows? Limit docs: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and-considerations Voting for PBI…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
2
votes
1 answer

Measure to SUM of more recent values using DAX from PowerBI

I have the following table: I need to SUM the values of more recent dates, which are the more recent? The MEASURE needs return the following value: 27 Why 27? Because it's the SUM of more recent values from which idOp. 100 - (2017-07-12) -…
D. Watson
  • 253
  • 1
  • 6
  • 20
2
votes
1 answer

Power BI Embedded report does not update in realtime even though the dataset is pushStreaming

I have created a streaming+push dataset in power BI. And i push the data through the rest apis. I can see the dashboard in power BI getting updated with the latest data. But the embedded report in my website doesn't seem to update. How can we…
Rima
  • 545
  • 6
  • 12
2
votes
2 answers

Load multiple files from folder without duplicating headers

I have used folder data source in Power BI the files are excel files with same structure each one of these files have columns names are first when I load the data I get the column name as row although i clicked in the "Use First row as header"…
asmgx
  • 7,328
  • 15
  • 82
  • 143
2
votes
2 answers

Using RANKX in PowerBI DAX

I am a PowerBI newbie and I have been playing with DAX functions, more specifically, the RANKX function. Here is my data set: +----------+-------------------------------------+-----------------+----------+ | Category | Sub Category …
Ali Parahoo
  • 161
  • 2
  • 11
2
votes
1 answer

Sum the value of one column based on the maximum value of another column

I need a measure to add the last non blank value from column SaldoConta from the table pcsa below from each column conta. The criteria to define last non blank is the one with maximum value in column AnoMes. conta ano mes AnoMes SaldoConta 110…
user882670
2
votes
1 answer

Direct query grayed out in Power BI

I am using Power BI which has been using a cached version of a query I now want to run it with the live query. Also, how do I use this if I am using two independent views for my data?
David B
  • 315
  • 3
  • 13
2
votes
1 answer

How to sum up at a lower granularity?

I created a DAX table. The granularity of the table from low to high is Expiry_Date_Year_Month, Expiry_Member_Type, Renewal_Channel. Below the DAX code. MemberRenewChannel = UNION( summarize( SELECTCOLUMNS(MemberRenew, , "Expiry_Date_Year_Month",…
Glyphfever
  • 145
  • 8
2
votes
3 answers

Grouping rows with similar values

I am trying to get a count of error types sorted by the users who experienced the error by name. However, username and systemname are not differentiated in my data. According to my data, systemname is just a username. I would like to make a bar…
Christopher
  • 790
  • 12
  • 30
2
votes
1 answer

Pass the values of a slicer selection to a list variable

I have a calculated table with an expression like: Table = VAR MyVar = {1;2;3} ... RETURN SELECTCOLUMNS(...) This returns a table with a single column. The rows depend on the list defined manually in MyVar. I'd like to pass the values of a slicer…
user882670
2
votes
1 answer

Automatically Expand all "Table Columns" with specific name

I'm a beginner in coding and am not familiar with "M" modeling language. I have an XML file that I want to use to load the data in Query Editor. In the Query, I need to expand only the table columns with a specific name…
Gangula
  • 5,193
  • 4
  • 30
  • 59
2
votes
1 answer

Calculate latest date for every index with DAX

I have a dataset in Power BI like this ID DATE 1 06/24/2016 1 06/24/2017 1 06/24/2018 2 08/08/2017 2 08/08/2016 3 12/12/2015 I would like to create a calculated column with DAX, in which i have to calculate the latest date for every…
aipam
  • 137
  • 3
  • 10
2
votes
3 answers

Power BI - Running Totals with Filters and Slicers

I want to create running totals (using a measure). However, if I apply slicers I want the values to adjust according to this selection. For example I have a table with my clothes purchases for 2017-2018 (date of purchase;brand of product; product…
Domingos Oliveira
  • 21
  • 1
  • 1
  • 3
1 2 3
…
99
100