Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Field parameters in Power BI dataset

Hello everyone,

 

I would like to create a field parameter directly in my Power BI dataset. 

Does someone know if it's possible ? I tried to do it throught Tabular Editor by creating a calculated table but it did no succeed.

 

Thanks for your help !

 

 

2 ACCEPTED SOLUTIONS
GilbertQ
Super User
Super User

Hi @Anonymous 

 

This is a brand new feature and I am sure it will be coming to Tabular Editor soon. I know it is not there yet...


What I would suggest as a workaround is to create it in Power BI Desktop, the use ALM toolkit and just deploy the changes to your Power BI Dataset (The dataset has to be in PPU or Premuium to deploy the change)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Anonymous
Not applicable

Hello @GilbertQ ,

 

Thanks for your answer !

 

Your solution worked, I succeed in creating a field parameter directly in my Power BI dataset. Please find below the process I have done to achieve this :

 

1 - Create a Power BI report and connect it to your Power BI dataset

2 - Set up the connection to "Direct Query" to allow the creation of field parameters

3 - Create your field parameter in Power BI Desktop

4 - Go on ALM Toolkit and compare your Power BI Dataset with your Power BI Report (in which you have created your field parameter)

5 - Deploy your field parameter in your Power BI Dataset

6 - Refresh the partition of the new created table (your field parameter)

7 - Enjoy !

 

Thanks again @GilbertQ !

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Thanks for letting us know!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Hello @GilbertQ ,

 

Thanks for your answer !

 

Your solution worked, I succeed in creating a field parameter directly in my Power BI dataset. Please find below the process I have done to achieve this :

 

1 - Create a Power BI report and connect it to your Power BI dataset

2 - Set up the connection to "Direct Query" to allow the creation of field parameters

3 - Create your field parameter in Power BI Desktop

4 - Go on ALM Toolkit and compare your Power BI Dataset with your Power BI Report (in which you have created your field parameter)

5 - Deploy your field parameter in your Power BI Dataset

6 - Refresh the partition of the new created table (your field parameter)

7 - Enjoy !

 

Thanks again @GilbertQ !

GilbertQ
Super User
Super User

Hi @Anonymous 

 

This is a brand new feature and I am sure it will be coming to Tabular Editor soon. I know it is not there yet...


What I would suggest as a workaround is to create it in Power BI Desktop, the use ALM toolkit and just deploy the changes to your Power BI Dataset (The dataset has to be in PPU or Premuium to deploy the change)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.