Recent questions tagged powerquery

0 votes
0 answers

How do you handle duplicate data entries and deduplication logic in Power BI transformations?

2 days ago in Power BI by Evanjalin
 • 5,530 points • 15 views
0 votes
0 answers

How do you handle JSON data parsing and transformations in Power BI dataflows?

2 days ago in Power BI by Evanjalin
 • 5,530 points • 11 views
0 votes
0 answers

How do you handle JSON data parsing and transformations in Power BI dataflows?

3 days ago in Power BI by Evanjalin
 • 5,530 points • 15 views
0 votes
0 answers

How do I create a rolling time window in Power BI visuals, such as the past 7 or 30 days?

Nov 14 in Power BI by Evanjalin
 • 5,530 points • 26 views
0 votes
1 answer

How can I optimize Power BI’s refresh schedule to avoid peak load times and ensure quick data availability?

Nov 12 in Power BI by Evanjalin
 • 5,530 points • 27 views
0 votes
1 answer

Why am I encountering issues when publishing reports to a Power BI workspace shared with multiple users?

Nov 11 in Power BI by Evanjalin
 • 5,530 points • 29 views
0 votes
1 answer

How do I calculate a rolling average or cumulative total in Power BI without performance issues?

Nov 7 in Power BI by Evanjalin
 • 5,530 points • 31 views
0 votes
1 answer

How do you manage complex drill-through reports when users encounter incorrect or missing data in drilldowns?

Nov 5 in Power BI by Evanjalin
 • 5,530 points • 22 views
0 votes
0 answers

What strategies do you use to avoid redundant transformations in Power Query that slow down data refresh?

Nov 5 in Power BI by Evanjalin
 • 5,530 points • 27 views
0 votes
0 answers

How do you resolve memory or performance issues when running large Power BI reports with heavy DAX calculations?

Nov 5 in Power BI by Evanjalin
 • 5,530 points • 25 views
0 votes
1 answer

What steps do you follow when visuals don’t display the expected results, even when the underlying data is correct?

Nov 4 in Power BI by Evanjalin
 • 5,530 points • 34 views
0 votes
0 answers

How do you manage complex drill-through reports when users encounter incorrect or missing data in drilldowns?

Nov 4 in Power BI by Evanjalin
 • 5,530 points • 30 views
0 votes
0 answers

How do you handle formatting issues when exporting Power BI reports to Excel or PDF, especially with large text tables?

Nov 4 in Power BI by Evanjalin
 • 5,530 points • 28 views
0 votes
1 answer

How do you optimize Power BI reports that perform poorly due to heavy DAX calculations?

Nov 4 in Power BI by Evanjalin
 • 5,530 points • 26 views
0 votes
1 answer

What common mistakes lead to slow report loading times, and how do you fix inefficient M code or DAX queries?

Nov 4 in Power BI by Evanjalin
 • 5,530 points • 31 views
0 votes
0 answers

How do you resolve issues when using DAX variables (VAR) that cause unexpected results in measures?

Nov 4 in Power BI by Evanjalin
 • 5,530 points • 25 views
0 votes
1 answer

How do you resolve issues when using DAX variables (VAR) that cause unexpected results in measures?

Oct 30 in Power BI by Evanjalin
 • 5,530 points • 45 views
0 votes
1 answer

How do you handle complex relationship-based calculations when multiple tables are involved in a DAX query?

Oct 30 in Power BI by Evanjalin
 • 5,530 points • 50 views
0 votes
0 answers

What debugging tools or methods do you use to pinpoint and resolve DAX or Power Query coding errors?

Oct 30 in Power BI by Evanjalin
 • 5,530 points • 48 views
0 votes
0 answers

How do you troubleshoot slow data model refreshes, especially when custom code (M or DAX) is involved?

Oct 30 in Power BI by Evanjalin
 • 5,530 points • 106 views
0 votes
0 answers

How do you resolve memory or performance issues when running large Power BI reports with heavy DAX calculations?

Oct 30 in Power BI by Evanjalin
 • 5,530 points • 57 views
0 votes
0 answers

What strategies do you use to avoid redundant transformations in Power Query that slow down data refresh?

Oct 30 in Power BI by Evanjalin
 • 5,530 points • 49 views
0 votes
1 answer

How do you troubleshoot performance issues with complex DAX measures in large datasets?

Oct 30 in Power BI by Evanjalin
 • 5,530 points • 61 views
0 votes
1 answer

How do you manage and optimize Power Query M code for transforming large datasets?

Oct 29 in Power BI by Evanjalin
 • 5,530 points • 43 views
0 votes
1 answer

What are common pitfalls when using Power Query M language for data transformations?

Oct 21 in Power BI by Evanjalin
 • 5,530 points • 56 views
0 votes
0 answers

What are common pitfalls when using Power Query M language for data transformations?

Oct 11 in Power BI by anonymous
 • 5,530 points • 78 views
0 votes
1 answer

Combing data from multiple workbooks into a single master workbook using power query

Apr 7, 2023 in Others by narikkadan
 • 63,600 points • 555 views
0 votes
1 answer

Power Query - Search an element of column A in entire column B

Mar 30, 2023 in Others by Kithuzzz
 • 38,000 points • 629 views
0 votes
1 answer

Issues with NULL in an added and custom column

Mar 24, 2023 in Others by narikkadan
 • 63,600 points • 438 views
0 votes
1 answer

How to merge the Two Columns with two different Tables without getting duplicates in either of the resulting columns

Mar 19, 2023 in Others by narikkadan
 • 63,600 points • 669 views
0 votes
1 answer

Add column from another table using excel power query

Feb 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,241 views
0 votes
1 answer

Filter a list by using another list in PowerQuery M code

Feb 23, 2023 in Others by narikkadan
 • 63,600 points • 2,021 views
0 votes
1 answer

Excel Power Query Moves old Data to the right

Feb 16, 2023 in Others by narikkadan
 • 63,600 points • 354 views
0 votes
1 answer

Power Query - Find matching contents from multiple other tables

Feb 16, 2023 in Others by narikkadan
 • 63,600 points • 534 views
0 votes
1 answer

Name not recognized error in List.Generate

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 678 views
0 votes
1 answer

How can I verify if a column is only decimal using Power Query M formula?

Feb 13, 2023 in Others by Kithuzzz
 • 38,000 points • 969 views
0 votes
1 answer

PowerQuery Extract everything before alphabet from a column

Feb 9, 2023 in Others by Kithuzzz
 • 38,000 points • 674 views
0 votes
1 answer

How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Feb 5, 2023 in Others by Kithuzzz
 • 38,000 points • 1,193 views
0 votes
1 answer

Power query to return true / false if multiple columns are either = or null

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 2,281 views
0 votes
1 answer

Power Query M Lookup on Same table with Filtering

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,406 views
0 votes
1 answer

Excel Power Query Group by

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 451 views
0 votes
1 answer

Stop power query from loading to excel sheet

Dec 17, 2022 in Others by Kithuzzz
 • 38,000 points • 5,271 views
0 votes
1 answer

Excel Power Query import (same file but with different month name)

Dec 12, 2022 in Others by Kithuzzz
 • 38,000 points • 944 views
0 votes
1 answer

Repeated excel rows based on a cell with multiple values

Oct 20, 2022 in Others by Kithuzzz
 • 38,000 points • 1,518 views
0 votes
1 answer

How to split text values by a delimiter?

Oct 11, 2022 in Others by Kithuzzz
 • 38,000 points • 694 views
0 votes
1 answer

Excel, How to split cells by comma delimiter into new cells

Oct 2, 2022 in Others by Kithuzzz
 • 38,000 points • 901 views
0 votes
1 answer

How can I prevent #REF errors in Excel when connecting to Databricks through ODBC?

Mar 23, 2022 in Azure by Edureka
 • 12,690 points • 568 views
0 votes
0 answers

How to import JSON file to Excel without coding?

Feb 24, 2022 in Database by Edureka
 • 13,690 points • 770 views
0 votes
1 answer

Custom title and logo in Power BI Report Server

Feb 9, 2022 in Power BI by surbhi
 • 3,820 points • 1,214 views
0 votes
1 answer

How to measure in DAX to calculate YTD for chosen month only for Power BI?

Dec 22, 2020 in Power BI by Roshni
 • 10,480 points • 4,870 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.