fbpx
Skip to content
DataChant
Menu
  • Book
    • Book Q&A
    • Excerpts & Extras
  • About
    • About Gil
    • Subscriber’s Corner
    • Archived Gallery
  • Power BI Apps on AppSource
    • Mailchimp
    • ActiveCampaign
    • ActiveCampaign PBIX Instructions
    • Dataflows Snapshot Analysis
    • Power Apps Dataflows Snapshot Analysis
    • Excel Compare
    • Twitter Dashboard
  • Book
    • Book Q&A
    • Excerpts & Extras
  • About
    • About Gil
    • Subscriber’s Corner
    • Archived Gallery
  • Power BI Apps on AppSource
    • Mailchimp
    • ActiveCampaign
    • ActiveCampaign PBIX Instructions
    • Dataflows Snapshot Analysis
    • Power Apps Dataflows Snapshot Analysis
    • Excel Compare
    • Twitter Dashboard

Tag: Pitfalls

#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, 201740
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, 201710
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, 201724
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, 201722
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, 201718
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 our Power BI Apps on AppSource

Tags

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

Blog Stats

  • 1,548,458 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 2021 DataChant Consulting LLC All Rights Reserved

 

Loading Comments...