fbpx
Skip to content
DataChant
Menu
  • Shop
    • All Products
  • Book
    • Book Q&A
    • Excerpts & Extras
  • Subscribe
  • Popular Articles
    • Popular
    • Facebook Insights
    • Sentiment Analysis
    • What is Power Query?
  • About
    • About Gil
    • Subscriber’s Corner
    • Archived Gallery
  • ActiveCampaign Email Marketing
  • Shop
    • All Products
  • Book
    • Book Q&A
    • Excerpts & Extras
  • Subscribe
  • Popular Articles
    • Popular
    • Facebook Insights
    • Sentiment Analysis
    • What is Power Query?
  • About
    • About Gil
    • Subscriber’s Corner
    • Archived Gallery
  • ActiveCampaign Email Marketing

Tag: Pitfalls

Power BI

#MSDataSummit Ten Pitfalls of the Data Wrangler using Power BI

Gil RavivJune 13, 20170
Meet Alice the Power BI Data Wrangler, and DBA Bob, and learn how Alice can survive the 10 pitfalls when there is no proper data contract with Bob. Here is...
Remove Duplicates and Lookup Tables Pitfall #10 in Power BI and Power Query Popular

Remove Duplicates, Lookup Tables and Pitfall #10 in #PowerBI and #PowerQuery

Gil RavivFebruary 14, 20173
In today's post, we will learn about the tenth pitfall in Power BI and Power Query in Excel (Read all pitfalls here). For this special occasion, we'll get...
Pitfall 9 in Power BI and Power Query in Excel - Expand Table Columns Popular

Expand Table Column – Pitfall #9

Gil RavivFebruary 7, 201737
It's time to expand table columns today, and get you acquainted with the ninth pitfall, which can be quite risky, as you'll soon find out. For those of you...
Pitfall 7 and 8 - Split and merge columns in Power BI Popular

Split & Merge Columns – Pitfalls #7 and #8

Gil RavivJanuary 31, 20171
In today's post, we will introduce the 7th and 8th pitfalls in Power BI and Power Query in Excel. To follow the pitfalls series, go here. The 7th and 8th...
Pitfall 6 - 10 mistakes you do in Power BI and Power Query in Excel Popular

Column Renaming and List.Zip To The Rescue – Pitfall #6 in #PowerBI #PowerQuery

Gil RavivJanuary 26, 20178
Today, we will learn how to avoid the 6th pitfall as part of the Power BI / Power Query Pitfalls series. The sixth pitfall is quite tricky, and is one of the...
Pitfall 5 in Power BI and Power Query in Excel Popular

Removing/Selecting Columns – Pitfall #5 in #PowerBI and #PowerQuery

Gil RavivJanuary 24, 201710
In today's episode of the Pitfalls Series (here), we will briefly discuss the fifth pitfall, which is one of the most common mistakes that you always do, when...
Pitfall 4 in Power BI and Power Query Popular

Column Reordering Disorder – Pitfall #4 in #PowerBI #PowerQuery

Gil RavivJanuary 18, 201718
Order is a crucial force in life, especially if you are a data analyst. But as we will see today, the misuse of order might cause an unexpected chaos. In...
10 mistakes you do in Power Query and Power BI and how to avoid pitfall #3 Popular

10 common mistakes you do in #PowerBI #PowerQuery – Pitfall #3

Gil RavivJanuary 16, 201720
Prologue In our last episode of the Pitfalls series here, we were introduced to Pitfall #2 - The automatic detection of column types, which can trigger...
Pitfall #2 - 10 common mistakes you do in #PowerBI #PowerQuery – And how to avoid pitfalls Popular

10 common mistakes you do in #PowerBI #PowerQuery – Pitfall #2

Gil RavivJanuary 11, 20176
In the last blog post, we outlined the challenge in creating robust queries that will be resilient to changes in data structure, and will not fail a refresh,...
Popular

10 common mistakes you do in #PowerBI #PowerQuery – And how to avoid pitfalls

Gil RavivJanuary 6, 201717
This is the first article in a series I would like to call Robust Queries in Power BI and Power Query. To follow this series click here. I've already used the...

Write a Review

Install DataChant Template Apps from AppSource

Custom Visuals Exploration Tool

Tags

#MSDataSummit AppSource Bad Practices Bonus Exercise Book COVID-19 Custom Visuals DAX Event Excel Excel 2016 Facebook Facebook bug Facebook Insights Facebook Reactions Get & Transform Jedi List.Accumulate List.Generate Logs Microsoft Cognitive Services Multiline records MVP Opponent Mentions Pitfalls PivotTable Power BI Power BI Governance Power Pivot Power Query Pulse Chart Robust Queries Sentiment Analysis Star Wars Subscribers Tableau vs Power BI Template Apps Text Analytics Unpivot Update US Election US Election Candidates US Presidential Candidates Webinar Web Scraping

Blog Stats

  • 1,032,628 Views
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy
  • Home
  • Shop
  • Book
  • About

Copyright 2020 DataChant Consulting LLC All Rights Reserved