Category: Power BI

How To Do Projection In Power Query/M Language

Posted on by Annie D

The field-access expression is used to select a value from a record or to “project” a record or table to one with fewer fields or columns, respectfully. In this tutorial, Melissa is going to delve into Projection in the Power Query/M Language, what it means, and how you can use it.

***** Video Details *****
00:00 Introduction
00:47 BaseRecord
01:50 Record.SelectFields
03:15 BaseTable
03:53 Table.SelectColumns

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources Continue reading “How To Do Projection In Power Query/M Language” →

Everything About Power BI Security | Business Intelligence Summit Session 14

Posted on by Annie D

Session 14: Everything About Power BI Security

When is it?
August 24th – 3pm Los Angeles (PDT), 6pm New York (EDT), 11pm London (BST)
August 25th – 8am Sydney (AEST), 10am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Chris Wagner (MVP), Senior Finance Data Analytics Solutions Architect at Rockwell Automation

During This Free Event, You Will Learn:

• Workspace & App Security
• Dataflow & Dataset Security
• Report Security
• Row Level Security
• Object Level Security
• Internal & External Sharing

If you have questions regarding this training, please send it to Continue reading “Everything About Power BI Security | Business Intelligence Summit Session 14” →

Simulate Hierarchies with Field Parameters in Power BI

Posted on by Annie D

Struggling with field parameters and hierarchies in Power BI? They just don’t work! Patrick has an approach that looks to simulate hierarchies by using field parameters in this way.

Let report readers use field parameters to change visuals (preview)
https://docs.microsoft.com/power-bi/create-reports/power-bi-field-parameters

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— Continue reading “Simulate Hierarchies with Field Parameters in Power BI” →

Clean Your Data Like A Pro | Business Intelligence Summit Session 12

Posted on by Annie D

Session 12: Practical Power Query Solutions: Clean Your Data Like A Pro

When is it?
August 24th – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
August 25th – 5am Sydney (AEST), 7am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Melissa de Korte, Enterprise DNA Expert

During This Free Event, You Will Learn:

• Explore common data cleaning scenarios.
• Use Power Query/ M effectively to prepare data for analysis.
• Built reusable solutions to make this task something to look forward to!
• Learn how to create Continue reading “Clean Your Data Like A Pro | Business Intelligence Summit Session 12” →

Let’s Merge Queries To Improve The Tabular Model | Business Intelligence Summit Session 14

Posted on by Annie D

Session 14: Let’s Merge Queries To Improve The Tabular Model

When is it?
August 24th – 1pm Los Angeles (PDT), 4pm New York (EDT), 9pm London (BST)
August 25th – 6am Sydney (AEST), 8am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Ana María Bisbé York (MVP), Business Intelligence Consultant

During This Free Event, You Will Learn:

• This session will demo several scenarios in which Combining queries could be the perfect solution for the optimal tabular model
• Learn how to combine queries to protect the fact tables in Continue reading “Let’s Merge Queries To Improve The Tabular Model | Business Intelligence Summit Session 14” →

Developing Data Models In The Real World | Business Intelligence Summit Session 12

Posted on by Annie D

Session 12: Developing Data Models In The Real World

When is it?
August 24th – 11am Los Angeles (PDT), 2pm New York (EDT), 7pm London (BST)
August 25th – 4am Sydney (AEST), 6am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by James Andrew, Founder of Matador Software

During This Free Event, You Will Learn:

• Discover the foundations of Data Modelling in Power BI and Power Query as well as the benefits by referring to techniques such as the Kimball methodology
• Understand how to prepare your Data in Power Continue reading “Developing Data Models In The Real World | Business Intelligence Summit Session 12” →

The (M)agic of List.Generate | Business Intelligence Summit Session 11

Posted on by Annie D

Session 11: The (M)agic of List.Generate

When is it?
August 24th – 9am Los Angeles (PDT), 12pm New York (EDT), 5pm London (BST)
August 25th – 2am Sydney (AEST), 4am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Rick de Groot (MVP), Founder of BI Gorilla

During This Free Event, You Will Learn:

• What does List.Generate do?
• Use cases where List.Generate proves useful
• Working with a single variable
• Incorporating multiple variables within the function
• Return transformed lists or partial results

If you have questions regarding this training, please send Continue reading “The (M)agic of List.Generate | Business Intelligence Summit Session 11” →

KEYNOTE: eDNA’s New Framework For Power BI | Business Intelligence Summit Session 1

Posted on by Annie D

Session 1: KEYNOTE: eDNA’s New Framework For Power BI

When is it?
August 23rd – 2pm Los Angeles (PDT), 5pm New York (EDT), 10pm London (BST)
August 24th – 7am Sydney (AEST), 9am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay – Founder & CEO of Enterprise DNA

During This Free Event, You Will Learn:

• Discover how eDNA has updated our Power BI development and implementation frameworks
• Learn how our new platform and tools empower fast and effective development
• Review all new features from new empowerment Continue reading “KEYNOTE: eDNA’s New Framework For Power BI | Business Intelligence Summit Session 1” →

How To Use Excel To Build & Validate Complex DAX | Business Intelligence Summit Session 5

Posted on by Annie D

Session 5: How To Use Excel To Build & Validate Complex DAX

When is it?
August 23rd – 10pm Los Angeles (PDT)
August 24th – 1am New York (EDT), 6am London (BST), 3pm Sydney (AEST), 5pm Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Chandeep Chhabra, Founder of Goodly

During This Free Event, You Will Learn:

• Know how to form DAX logic by creating Excel rough work
• Discover how to visualize and solve complex DAX problems using Excel
• Learn to debug and validate calculations using Excel

If you have Continue reading “How To Use Excel To Build & Validate Complex DAX | Business Intelligence Summit Session 5” →

Next Level Field Parameters | Business Intelligence Summit Session 4

Posted on by Annie D

Session 4: Next Level Field Parameters

When is it?
August 23rd – 8pm Los Angeles (PDT), 11pm New York (EDT)
August 24th – 4am London (BST), 1pm Sydney (AEST), 3pm Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Kane Snyder, Principal Consultant at Agile Analytics

During This Free Event, You Will Learn:

• Use field parameters to implement complex slicer interactions
• Filter your model with field parameters to restrict the data visible with different columns used in visuals
• Calculation Groups and Field Parameters: When to use each and where Continue reading “Next Level Field Parameters | Business Intelligence Summit Session 4” →

Power Query: Refencing Vs. Duplicating Queries | Business Intelligence Summit Session 3

Posted on by Annie D

Session 3: Power Query: Refencing Vs. Duplicating Queries

When is it?
August 23rd – 6pm Los Angeles (PDT), 9pm New York (EDT)
August 24th – 2am London (BST), 11am Sydney (AEST), 1pm Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Oz Du Soleil (MVP), Founder of Excel on Fire

During This Free Event, You Will Learn:

• Showcase the importance of referencing a query
• Learn and understand how to duplicate a query effectively
• Discuss the difference between referencing vs. duplicating
• Know the techniques how to be strategic in your Continue reading “Power Query: Refencing Vs. Duplicating Queries | Business Intelligence Summit Session 3” →

What is this delta lake thing?

Posted on by Annie D

You may be using a lake for your data and it may just be regular parquet files. In this video, Stijn joins us to explain why you should be using a delta lake instead and how this works in Azure Synapse Analytics.

Connect with Stijn
https://twitter.com/SQLStijn

What is Delta Lake
https://docs.microsoft.com/azure/synapse-analytics/spark/apache-spark-what-is-delta-lake

Delta Lake Documentation
https://docs.delta.io/latest/delta-intro.html

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— rel=”nofollow”>http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#AzureSynapse #DeltaLake #GuyInACube