Recent questions tagged power-bi

0 votes
1 answer

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

Mar 13 in Power BI by Evanjalin
 • 30,660 points • 88 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?

Mar 13 in Power BI by Evanjalin
 • 30,660 points • 123 views
0 votes
1 answer

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

Mar 13 in Power BI by Evanjalin
 • 30,660 points • 108 views
0 votes
1 answer

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

Mar 13 in Power BI by Evanjalin
 • 30,660 points • 73 views
0 votes
1 answer

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

Mar 13 in Power BI by Evanjalin
 • 30,660 points • 99 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?

Mar 11 in Power BI by Evanjalin
 • 30,660 points • 132 views
0 votes
1 answer

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

Mar 11 in Power BI by Evanjalin
 • 30,660 points • 86 views
0 votes
1 answer

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

Mar 11 in Power BI by Evanjalin
 • 30,660 points • 91 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?

Mar 11 in Power BI by Evanjalin
 • 30,660 points • 118 views
0 votes
1 answer

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

Mar 11 in Power BI by Evanjalin
 • 30,660 points • 118 views
0 votes
1 answer

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

Mar 11 in Power BI by Evanjalin
 • 30,660 points • 82 views
0 votes
1 answer

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

Mar 11 in Power BI by Evanjalin
 • 30,660 points • 79 views
0 votes
1 answer

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

Mar 11 in Power BI by Evanjalin
 • 30,660 points • 105 views
0 votes
1 answer

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

Mar 10 in Power BI by Evanjalin
 • 30,660 points • 116 views
0 votes
1 answer

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

Mar 10 in Power BI by Evanjalin
 • 30,660 points • 85 views
0 votes
1 answer

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

Mar 10 in Power BI by Evanjalin
 • 30,660 points • 110 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?

Mar 10 in Power BI by anonymous
 • 30,660 points • 133 views
0 votes
1 answer

How can I optimize a SUMX() function that is performing poorly on large datasets?

Mar 10 in Power BI by Evanjalin
 • 30,660 points • 83 views
0 votes
1 answer

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

Mar 10 in Power BI by Evanjalin
 • 30,660 points • 131 views
0 votes
1 answer

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

Mar 10 in Power BI by Evanjalin
 • 30,660 points • 123 views
0 votes
1 answer

How do I handle many-to-many relationships in Power BI without creating ambiguous relationships in the model?

Mar 10 in Power BI by Evanjalin
 • 30,660 points • 96 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?

Mar 7 in Power BI by Evanjalin
 • 30,660 points • 128 views
0 votes
1 answer

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

Mar 7 in Power BI by Evanjalin
 • 30,660 points • 137 views
0 votes
1 answer

Your Power BI dataset has millions of rows and is causing memory issues. How can you reduce the dataset size without losing key insights?

Mar 7 in Power BI by Evanjalin
 • 30,660 points • 143 views
0 votes
1 answer

A dataset contains customer transactions, and your report is aggregating data at multiple levels (daily, monthly, and yearly). Should you use Import Mode or DirectQuery for optimal performance?

Mar 7 in Power BI by Evanjalin
 • 30,660 points • 125 views
0 votes
1 answer

Your dataset contains multiple fact tables (Sales, Inventory, and Finance). Should you create relationships between them directly, or use a bridge table? Why?

Mar 7 in Power BI by Evanjalin
 • 30,660 points • 118 views
0 votes
1 answer

Your Power BI report is slow when switching slicer values, and your DAX measures are using FILTER extensively. What steps can you take to improve performance?

Mar 6 in Power BI by Evanjalin
 • 30,660 points • 120 views
0 votes
1 answer

You are working with a large dataset (10M+ rows) and your Power BI report is taking too long to refresh. How can you optimize it for better performance?

Mar 6 in Power BI by Evanjalin
 • 30,660 points • 125 views
0 votes
1 answer

A client needs a map visualization showing sales per city, but the dataset lacks latitude/longitude coordinates. How can you ensure accurate city placement in Power BI?

Mar 6 in Power BI by Evanjalin
 • 30,660 points • 84 views
0 votes
1 answer

The client wants a KPI card that displays “Sales Performance” in red if below target, yellow if close, and green if above target. How can you achieve this in Power BI?

Mar 6 in Power BI by Evanjalin
 • 30,660 points • 110 views
0 votes
1 answer

Your report contains multiple visuals, but users are getting confused when they filter data because they don’t know which filters are applied. How can you improve the user experience?

Mar 6 in Power BI by Evanjalin
 • 30,660 points • 101 views
0 votes
1 answer

Implementing a Slicer to Toggle Between Daily, Monthly, and Yearly Sales Aggregation

Mar 5 in Power BI by Evanjalin
 • 30,660 points • 90 views
0 votes
1 answer

Filling Missing Values with the Previous Available Value in Power Query

Mar 5 in Power BI by Evanjalin
 • 30,660 points • 141 views
0 votes
1 answer

Handling Text-Based Date Columns with Errors in Power Query

Mar 5 in Power BI by Evanjalin
 • 30,660 points • 143 views
0 votes
1 answer

Standardizing Customer Names to Proper Case in Power Query

Mar 5 in Power BI by Evanjalin
 • 30,660 points • 115 views
0 votes
1 answer

Automating Monthly Sales Data Consolidation from SharePoint

Mar 5 in Power BI by Evanjalin
 • 30,660 points • 71 views
0 votes
1 answer

Comparing Year-to-Date (YTD) vs. Previous Year YTD in a Financial Dashboard

Mar 5 in Power BI by Evanjalin
 • 30,660 points • 108 views
0 votes
1 answer

Categorizing Employees Based on Sales Performance

Mar 5 in Power BI by Evanjalin
 • 30,660 points • 106 views
0 votes
1 answer

How to Calculate Dynamic Regional Sales Percentage in DAX?

Mar 3 in Power BI by Evanjalin
 • 30,660 points • 99 views
0 votes
1 answer

How to Calculate Total Sales for the Last 3 Months Dynamically in DAX?

Mar 3 in Power BI by Evanjalin
 • 30,660 points • 120 views
0 votes
1 answer

Is it possible to store data in Power BI statically so that it remains unchanged after a data refresh? If so, how can this be implemented?

Mar 3 in Power BI by Evanjalin
 • 30,660 points • 103 views
0 votes
1 answer

Is there a way in Power BI Desktop to transform multiple text column values into a single row, grouped by another column?

Mar 3 in Power BI by Evanjalin
 • 30,660 points • 85 views
0 votes
1 answer

What are the steps to properly configure permissions for an application to access Microsoft Fabric services, and what common issues should I watch out for?

Feb 28 in Power BI by Evanjalin
 • 30,660 points • 162 views
0 votes
1 answer

Why do I get a 401 (unauthorized) error when using a service principal access token to call the Users.GetUserArtifactAccessAsAdmin API in Power BI?

Feb 28 in Power BI by Evanjalin
 • 30,660 points • 253 views
0 votes
1 answer

What are the steps to create and customize a Waterfall chart in Power BI?

Feb 28 in Power BI by Evanjalin
 • 30,660 points • 180 views
0 votes
1 answer

How can OData be efficiently used in Power BI for connecting to and managing data sources?

Feb 28 in Power BI by Evanjalin
 • 30,660 points • 220 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?

Feb 28 in Power BI by Evanjalin
 • 30,660 points • 226 views
0 votes
1 answer

How do I revert from using refresh policies with an EffectiveDate to using the current date in Tabular Editor 3?

Feb 28 in Power BI by Evanjalin
 • 30,660 points • 170 views
0 votes
1 answer

What could be causing issues when trying to fetch data from Custom Analytics Views in the Azure DevOps API, and how can I resolve them?

Feb 28 in Power BI by Evanjalin
 • 30,660 points • 128 views
0 votes
1 answer

Why does ALLSELECTED in my DAX query return unexpected results, and how can I debug or fix it?

Feb 28 in Power BI by Evanjalin
 • 30,660 points • 158 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.