Do you have a lot of tables originating from the same data source in Power BI?

@jennytumay

2.1K followers · usually 1.9K views a post

Views

5.9K

Likes

56

Comments

0

Shares

8

SoundTikTok sound · Running Up That Hill (A Deal With God)

Promoted product

Power BI

Sign in to Microsoft Power BI for intuitive data visualization, detailed analytics, and interactive dashboards. Unlock your data's full potential.

12 videos3 creators

Why it worked

The video provides a practical and efficient solution to a common problem faced by Power BI users, making it highly shareable and valuable content for those working with data sources.

Summary

This video demonstrates a Power BI life hack using parameters to easily switch between different data sources. The creator shows how to create a parameter for the data source URL, allowing for quick changes between 'test' and 'prod' environments.

Structure

1Introduction to the problem of multiple tables from the same data source
2Demonstration of creating a new parameter in Power BI
3Setting the parameter name and type
4

Original caption

Learn Power BI parameters in power query!! #powerbi #powerbitips #powerbiparameters

More from @jennytumay

Product placement

Power BI: A business intelligence tool that allows users to visualize data and share insights. It ACTS here as the interface being operated to demonstrate a feature. Removing it would change what happens in the video.

On-screen text

Power BI Life Hack feat. Parameters

Transcript

Do you have a lot of tables originating from the same data source in Power BI? Right click New Parameter... Name current data source Description Required Type Any Suggested Values Any value Current Value test Or data source link prod current data source current data source = OData.Feed("https://fef.m.azure.com/", null, [Implementation="2.0"]) mamCheckins_table = Source{[Name="mamCheckins",Signature="Set"]}[Data] mamCheckins_table current data source (https://fef.m.azure.com/) 2 COLUMNS, 3 ROWS Column profiling ba Editor Manage Parameters Refresh Preview Properties Advanced Editor Manage Query Current Value test Manage Parameter Current Value prod Manage Parameter This little hack is great if you know you're going to be doing a lot of lift and shifting or switching your schema from test to prod. Prod test.