Recent questions tagged powerquery

0 votes
1 answer

How can I track changes to sensitivity labels in Power BI reports?

Apr 29 in Power BI by Evanjalin
 • 29,310 points • 144 views
0 votes
1 answer

How can I prevent users from removing sensitivity labels in Power BI?

Apr 29 in Power BI by Evanjalin
 • 29,310 points • 158 views
0 votes
1 answer

How can I configure sensitivity labels for Power BI reports shared with external users?

Apr 29 in Power BI by Evanjalin
 • 29,310 points • 128 views
0 votes
1 answer

How do I connect Power BI with SAP BW without performance issues?

Apr 16 in Power BI by Evanjalin
 • 29,310 points • 124 views
0 votes
0 answers

How do I connect Power BI with SAP BW without performance issues?

Apr 16 in Power BI by Evanjalin
 • 29,310 points • 49 views
0 votes
1 answer

Handling Text-Based Date Columns with Errors in Power Query

Mar 5 in Power BI by Evanjalin
 • 29,310 points • 243 views
0 votes
1 answer

Standardizing Customer Names to Proper Case in Power Query

Mar 5 in Power BI by Evanjalin
 • 29,310 points • 177 views
0 votes
1 answer

What are the correct steps to set up Power BI with Amazon Redshift using an ODBC driver?

Feb 24 in Power BI by Evanjalin
 • 29,310 points • 184 views
0 votes
1 answer

Tandem Power BI Connector – Any Experience? – Has anyone used the Tandem Power BI Connector? Is it reliable for large datasets?

Feb 12 in Power BI by Evanjalin
 • 29,310 points • 169 views
+1 vote
2 answers

Power BI and Redshift ODBC Driver Issues – Anyone using the Redshift ODBC driver with Power BI? Running into connection problems.

Feb 12 in Power BI by Evanjalin
 • 29,310 points • 175 views
+1 vote
2 answers

Configuring MuleSoft Power BI Connector with OAuth? – Anyone successfully configured the MuleSoft Power BI connector using OAuth? Running into authentication issues.

Feb 11 in Power BI by Evanjalin
 • 29,310 points • 208 views
+1 vote
1 answer

Why am I getting a "NameError" while running a Python script in Power BI?

Dec 13, 2024 in Power BI by Evanjalin
 • 29,310 points • 254 views
+1 vote
2 answers

How can you efficiently manage Power BI’s incremental refresh for very large tables, such as sales or transactional data?

Nov 26, 2024 in Power BI by Evanjalin
 • 29,310 points • 267 views
+1 vote
2 answers

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

Nov 19, 2024 in Power BI by Evanjalin
 • 29,310 points • 285 views
+1 vote
2 answers

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

Nov 19, 2024 in Power BI by Evanjalin
 • 29,310 points • 284 views
0 votes
0 answers

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

Nov 18, 2024 in Power BI by Evanjalin
 • 29,310 points • 123 views
0 votes
2 answers

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

Nov 14, 2024 in Power BI by Evanjalin
 • 29,310 points • 309 views
+1 vote
2 answers

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

Nov 12, 2024 in Power BI by Evanjalin
 • 29,310 points • 288 views
+1 vote
2 answers

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

Nov 11, 2024 in Power BI by Evanjalin
 • 29,310 points • 330 views
0 votes
1 answer

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

Nov 7, 2024 in Power BI by Evanjalin
 • 29,310 points • 301 views
0 votes
1 answer

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

Nov 5, 2024 in Power BI by Evanjalin
 • 29,310 points • 270 views
0 votes
0 answers

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

Nov 5, 2024 in Power BI by Evanjalin
 • 29,310 points • 303 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, 2024 in Power BI by Evanjalin
 • 29,310 points • 258 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, 2024 in Power BI by Evanjalin
 • 29,310 points • 246 views
0 votes
0 answers

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

Nov 4, 2024 in Power BI by Evanjalin
 • 29,310 points • 190 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, 2024 in Power BI by Evanjalin
 • 29,310 points • 222 views
0 votes
1 answer

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

Nov 4, 2024 in Power BI by Evanjalin
 • 29,310 points • 272 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, 2024 in Power BI by Evanjalin
 • 29,310 points • 315 views
+1 vote
0 answers

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

Nov 4, 2024 in Power BI by Evanjalin
 • 29,310 points • 167 views
0 votes
1 answer

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

Oct 30, 2024 in Power BI by Evanjalin
 • 29,310 points • 275 views
+1 vote
1 answer

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

Oct 30, 2024 in Power BI by Evanjalin
 • 29,310 points • 299 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, 2024 in Power BI by Evanjalin
 • 29,310 points • 221 views
0 votes
0 answers

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

Oct 30, 2024 in Power BI by Evanjalin
 • 29,310 points • 493 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, 2024 in Power BI by Evanjalin
 • 29,310 points • 298 views
0 votes
0 answers

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

Oct 30, 2024 in Power BI by Evanjalin
 • 29,310 points • 203 views
+1 vote
1 answer

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

Oct 30, 2024 in Power BI by Evanjalin
 • 29,310 points • 400 views
0 votes
1 answer

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

Oct 29, 2024 in Power BI by Evanjalin
 • 29,310 points • 389 views
0 votes
2 answers

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

Oct 21, 2024 in Power BI by Evanjalin
 • 29,310 points • 311 views
0 votes
0 answers

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

Oct 11, 2024 in Power BI by anonymous
 • 29,310 points • 200 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
 • 86,360 points • 921 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 • 909 views
0 votes
1 answer

Issues with NULL in an added and custom column

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 628 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
 • 86,360 points • 901 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,614 views
0 votes
1 answer

Filter a list by using another list in PowerQuery M code

Feb 23, 2023 in Others by narikkadan
 • 86,360 points • 2,355 views
0 votes
1 answer

Excel Power Query Moves old Data to the right

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 529 views
0 votes
1 answer

Power Query - Find matching contents from multiple other tables

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 832 views
0 votes
1 answer

Name not recognized error in List.Generate

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 897 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 • 1,290 views
0 votes
1 answer

PowerQuery Extract everything before alphabet from a column

Feb 9, 2023 in Others by Kithuzzz
 • 38,000 points • 957 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.