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: Robust Queries

Protected: Subscriber’s Resource: Robust Column Merge

Protected: Subscriber’s Resource: Robust Column Merge

This content is password protected. To view it please enter your password below: Password:...
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 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...
Popular

Robust Queries: Convert column types and merge columns without referencing column names

Gil RavivOctober 7, 20164
Converting column types, and merging columns are common transformations in Power Query. It is so easy to perform these transformations through the Query...

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,543,196 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...