cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Variable Repository

Hi all,

 

I am new with the Power BI technology and I was wondering if there's any way to create a repository of variables. It means, having a shared file where all the variables are declared and you can just load them with PowerBI.

This will allow us to re-use variables from different projects and also to centralize the expressions with no need to use Power BI in case that a correction is needed.

 

Thank you,
Jose

2 REPLIES 2
Highlighted
Resolver II
Resolver II

Re: Variable Repository

Hey @jgual 

Although many users have requested global variables, that isn't part of the product at this time. 

What your requesting is a bit different, but PBI doesn't have that capability either. You could try to work toward having standard measures in a PBI file, & then sharing that 'base' file with colleagues; however, the presumption then is that all colleagues will be working with the same data set, same table names, & same column names.

Highlighted
Community Support
Community Support

Re: Variable Repository

Hi @jgual ,

Do you mean template pbix file with variable query parameters? If this is a case, you can create template files and modify query parameters to generate a new report file.

Deep Dive into Query Parameters and Power BI Templates

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors