Trending questions in Power BI

0 votes
1 answer

How do I embed interactive Power BI visuals in a paginated report?

To embed interactive Power BI visuals into ...READ MORE

Mar 19 in Power BI by anonymous
 • 36,180 points • 367 views
0 votes
1 answer

How can I create a function in Power Query that processes data differently based on a user-selected parameter?

The following steps outline the creation of ...READ MORE

Mar 17 in Power BI by anonymous
 • 36,180 points • 447 views
0 votes
1 answer

How do I create a paginated report with an interactive drill-through from a Power BI dashboard?

These are the steps to establish a ...READ MORE

Mar 19 in Power BI by anonymous
 • 36,180 points • 352 views
0 votes
1 answer

How do I optimize a paginated report that has complex expressions and multiple sub-reports?

Optimizing a paginated report with complicated expressions ...READ MORE

Mar 19 in Power BI by anonymous
 • 36,180 points • 346 views
0 votes
1 answer

How can I create a multi-row card that dynamically adjusts based on the number of selected values?

To create a multi-row card in Power ...READ MORE

Mar 18 in Power BI by anonymous
 • 36,180 points • 375 views
0 votes
1 answer

What’s the best way to handle slow row-level security (RLS) filters applied to large datasets?

The implementation of Row-Level Security (RLS) on ...READ MORE

Mar 11 in Power BI by anonymous
 • 36,180 points • 669 views
+1 vote
2 answers

How do R or Python scripts impact Power BI report performance, and how can I optimize them?

Scripting with R and Python can have ...READ MORE

Jan 13 in Power BI by pooja
 • 24,450 points • 715 views
0 votes
1 answer

I need to generate a paginated report where each customer gets a separate PDF—what’s the best approach?

In order to create a paginated report ...READ MORE

Mar 19 in Power BI by anonymous
 • 36,180 points • 292 views
0 votes
1 answer

How do I create a dynamic KPI card that changes color based on user-selected thresholds?

To create a dynamic KPI card that ...READ MORE

Mar 17 in Power BI by anonymous
 • 36,180 points • 371 views
+1 vote
2 answers

Is it possible to use both R and Python scripts in the same Power BI report? If so, how do they interact?

It has already been established that one ...READ MORE

Jan 13 in Power BI by pooja
 • 24,450 points • 681 views
0 votes
1 answer

How do I implement a dynamic segmentation analysis where customers are grouped based on sales trends?

To achieve dynamic segmentation of customers based ...READ MORE

Mar 18 in Power BI by anonymous
 • 36,180 points • 288 views
+1 vote
2 answers

Why is the "Visual" tab missing in the formatting pane for a custom visual in Power BI?

The custom visual loses the "Visual" tab ...READ MORE

Jan 8 in Power BI by pooja
 • 24,450 points • 918 views
0 votes
1 answer

I need to merge two tables in Power Query but maintain a one-to-many relationship—what’s the best approach?

In Power Query, to merge two tables ...READ MORE

Mar 11 in Power BI by anonymous
 • 36,180 points • 530 views
+1 vote
2 answers

What are the prerequisites for running R scripts in Power BI Desktop, and how do I troubleshoot script failures?

The tedious way and probable fixes are ...READ MORE

Jan 13 in Power BI by pooja
 • 24,450 points • 584 views
0 votes
1 answer

I need to calculate a running total but reset it at the start of each new quarter—how can I achieve this in DAX?

To calculate a running total that resets ...READ MORE

Mar 7 in Power BI by anonymous
 • 36,180 points • 645 views
+1 vote
2 answers

How can I display data in Power BI as a hierarchy when it contains multiple nested self-referential relationships?

Steps for the presentation of hierarchical data with nested self-referential ...READ MORE

Jan 23 in Power BI by pooja
 • 24,450 points • 627 views
0 votes
1 answer

How can I create a rolling calendar table that updates automatically based on the latest data in my fact table?

You can use either Power Query or ...READ MORE

Mar 13 in Power BI by anonymous
 • 36,180 points • 387 views
+1 vote
2 answers

What are the best practices for improving performance when using DirectQuery in Power BI to retrieve data from SQL Server?

For optimization in Power BI while using DirectQuery with SQL Server, best practices include the ...READ MORE

Jan 23 in Power BI by pooja
 • 24,450 points • 625 views
+1 vote
2 answers

How can I create advanced custom visualizations using Python in Power BI? Any best practices?

Create a more complex visualization aptly using ...READ MORE

Jan 13 in Power BI by pooja
 • 24,450 points • 538 views
0 votes
1 answer

How can I unpivot multiple columns dynamically while keeping other columns unchanged in Power Query?

To dynamically unpivot multiple columns in Power ...READ MORE

Mar 11 in Power BI by anonymous
 • 36,180 points • 457 views
0 votes
1 answer

How do I identify and remove inefficient calculated columns in a Power BI dataset?

Here are the best practices for identifying ...READ MORE

Mar 11 in Power BI by anonymous
 • 36,180 points • 462 views
0 votes
1 answer

How can I reduce the dataset size of a Power BI model that keeps hitting memory limits on Power BI Service?

In order to shrink the Power BI ...READ MORE

Mar 11 in Power BI by anonymous
 • 36,180 points • 435 views
+1 vote
2 answers

How can I manage library dependencies when using Python in Power BI to avoid errors during script execution?

Driving Python library dependencies for the effective ...READ MORE

Jan 13 in Power BI by pooja
 • 24,450 points • 502 views
0 votes
1 answer

Why does my Power BI report take so long to refresh when using multiple complex calculated tables?

Power BI Table Refresh Dynamics Unlike imported tables, ...READ MORE

Mar 11 in Power BI by anonymous
 • 36,180 points • 429 views
0 votes
1 answer

How do I create an optimized star schema for Power BI when dealing with high-cardinality dimensions?

Here are a few tips to properly ...READ MORE

Mar 11 in Power BI by anonymous
 • 36,180 points • 428 views
0 votes
1 answer

How do I extract JSON data from an API and transform it into a structured table in Power Query?

To extract and transform JSON data from ...READ MORE

Mar 13 in Power BI by anonymous
 • 36,180 points • 345 views
0 votes
1 answer

How do I handle dynamically changing column names in Power Query without breaking my transformations?

To handle dynamic column names in Power ...READ MORE

Mar 13 in Power BI by anonymous
 • 36,180 points • 335 views
0 votes
1 answer

I want to calculate the distinct count of active customers but only for the last three completed months—how can I do this in DAX?

To calculate the distinct count of active ...READ MORE

Mar 10 in Power BI by anonymous
 • 36,180 points • 460 views
0 votes
1 answer

How can I create a measure that calculates the weighted average of a column dynamically based on slicer selections?

Using SUMX and DIVIDE in DAX, a ...READ MORE

Mar 10 in Power BI by anonymous
 • 36,180 points • 455 views
0 votes
1 answer

How do I create a Power Query function that dynamically adjusts based on input parameters?

If you want to build a Power ...READ MORE

Mar 13 in Power BI by anonymous
 • 36,180 points • 322 views
+1 vote
1 answer

What are the different ways to integrate Bloomberg data into Power BI, and what challenges should I expect?

Integrating Bloomberg financial data into Power BI ...READ MORE

Feb 27 in Power BI by anonymous
 • 36,180 points • 939 views
+1 vote
1 answer

Why am I getting a 401 Unauthorized error when renaming a Power BI dataflow using the Power BI REST API, and how can I fix it?

A 401 Unauthorized error when renaming a ...READ MORE

Feb 27 in Power BI by anonymous
 • 36,180 points • 938 views
0 votes
1 answer

I need to compute a year-over-year (YoY) growth rate but only for months where I have data in both years—how do I do this?

Calculating Year-over-Year (YoY) growth only for those ...READ MORE

Mar 10 in Power BI by anonymous
 • 36,180 points • 441 views
0 votes
1 answer

My calculated column works in Power BI Desktop but breaks when I switch to DirectQuery mode—why?

When switching to DirectQuery mode, the following ...READ MORE

Mar 10 in Power BI by anonymous
 • 36,180 points • 426 views
0 votes
1 answer

What’s the best way to index my SQL database to speed up DirectQuery performance in Power BI?

Here's a demo of some effective indexing ...READ MORE

Mar 11 in Power BI by anonymous
 • 36,180 points • 370 views
0 votes
1 answer

My performance analyzer shows a high DAX query time—how can I optimize my measures?

These are the tools you would use ...READ MORE

Mar 11 in Power BI by anonymous
 • 36,180 points • 364 views
+1 vote
2 answers

When should I choose R over Python (or vice versa) for Power BI integration? Are there specific strengths or limitations?

R vs. Python in Power BI: R is best suited for: Statistical ...READ MORE

Jan 23 in Power BI by anonymous
 • 24,450 points • 526 views
0 votes
1 answer

How do I dynamically switch measures in Power BI based on a slicer selection while maintaining performance?

To dynamically switch between different measures in ...READ MORE

Mar 10 in Power BI by anonymous
 • 36,180 points • 416 views
0 votes
1 answer

How can I use RANKX() in DAX to rank customers within each region while keeping ties properly handled?

The RANKX() function allows you to rank ...READ MORE

Mar 10 in Power BI by anonymous
 • 36,180 points • 411 views
+1 vote
2 answers

What are the steps to integrate Python scripts into Power BI for data transformation or visualization?

To include Python scripts in Power BI for data transformation or ...READ MORE

Jan 23 in Power BI by anonymous
 • 24,450 points • 507 views
0 votes
1 answer

Handling Text-Based Date Columns with Errors in Power Query

To correctly transform a text-based date column ...READ MORE

Mar 5 in Power BI by anonymous
 • 36,180 points • 612 views
0 votes
1 answer

I have a dataset where column data types change frequently—how can I create a dynamic transformation process?

To allow for occasional changes to column ...READ MORE

Mar 13 in Power BI by anonymous
 • 36,180 points • 255 views
+1 vote
2 answers

Why is my DAX measure for dynamic percent change returning no value?

It is often noted that the problem ...READ MORE

Jan 8 in Power BI by pooja
 • 24,450 points • 659 views
0 votes
1 answer

Why is the RLS role not being applied when executing queries via the Power BI REST API using PowerShell, and how can I fix it?

RLS roles may not be applied when ...READ MORE

Feb 28 in Power BI by anonymous
 • 36,180 points • 801 views
0 votes
1 answer

How do I improve query performance when working with large fact tables in DirectQuery mode?

To increase query performance while working with ...READ MORE

Mar 11 in Power BI by anonymous
 • 36,180 points • 331 views
0 votes
1 answer

How can I create a dynamic date range filter that automatically adjusts based on user-selected slicer values?

To create a dynamic date range filter ...READ MORE

Mar 7 in Power BI by anonymous
 • 36,180 points • 486 views
+1 vote
2 answers

How can I expose a custom query as a reusable view in an existing Power BI dashboard?

The steps to make customizable queries towards ...READ MORE

Jan 23 in Power BI by pooja
 • 24,450 points • 470 views
+1 vote
1 answer

What is the process for updating key credentials of a Databricks data source via the Power BI REST API?

Updating Databricks Credentials in Power BI via ...READ MORE

Feb 27 in Power BI by anonymous
 • 36,180 points • 780 views
0 votes
1 answer

My Power BI report is slow when using multiple DISTINCTCOUNT() measures—what optimization techniques should I use?

Here are a few ways to tune ...READ MORE

Mar 10 in Power BI by anonymous
 • 36,180 points • 356 views
0 votes
1 answer

How can I reduce the memory usage of a complex DAX calculation that involves multiple SUMX() iterations?

To reduce memory usage in a complex ...READ MORE

Mar 10 in Power BI by anonymous
 • 36,180 points • 337 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.