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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
powerinbi
Frequent Visitor

Publish to web without parameters

Hi guys!

 

I have been working with sales data in Power BI desktop, which in itself has millions of rows.

To take some pressure of the data load, when loading data from query editor into the PBI interface, I have applied query parameters on the date column inside the sales table. For example, instead of taking the sales data from 1999, it takes it from 2019, which is specified with the parameter. 

 

I would now like to publish this report into the web, but instead of including only those few rows from 2019, I need it to include all the rows from the table. In other words, I need to disable the parameter when publishing to the web. 

 

Is there a way to achieve that?

 

Or is there a smarter way, where I can only work with handful of rows from sales table in PBI desktop, but where the published report has all the rows from the sales table?

 

Thanks guys!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@powerinbi , You can create parameters in the power query and filter that 2019 and above. Then on service change that 1999 onward using the three dots on datasets and setting. And then refresh data . But every time you upload a file this will overwrite 

 

Deployment Pipeline is better option. But might not be fit for this

Premium- Deployment Pipeline, Load More Data on Test/Prod : https://youtu.be/l69cnWkoGX0

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@powerinbi , You can create parameters in the power query and filter that 2019 and above. Then on service change that 1999 onward using the three dots on datasets and setting. And then refresh data . But every time you upload a file this will overwrite 

 

Deployment Pipeline is better option. But might not be fit for this

Premium- Deployment Pipeline, Load More Data on Test/Prod : https://youtu.be/l69cnWkoGX0

@amitchandak Ahh thanks for the reply, to be able to change these parameters in PBI web is exactly what I needed. 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.