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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
gsxJohnny
Regular Visitor

Some parameters are greyed out

On PowerBI desktop we open a .pbit file.

On this template we have 4 parameters. Server and database are for connection. (tried with type Any and Text)

gsxJohnny_0-1596466475758.png

 

When we publish it, we click on “Apply later” button.

gsxJohnny_1-1596466475761.png

 

On publishing success, we open it in PowerBI Service. Go to its dataset settings and the parameters used for connection are greyed and values are not equals to values changed before publishing

gsxJohnny_1-1596466685316.png

 

1 ACCEPTED SOLUTION

Thank you for your response,

 

Yes, I enabled the incremental refresh.

I ask to support and they helps me to fix it.

It was disabled because of type Any, I changed the type into text, and the Apply Later did not take into account changes of the type of the parameters publishing the report. 

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @gsxJohnny,

I think you are work with a report who enabled the incremental refresh, right? If this is a case, I think your issue should be related to it. It seems like an incremental refresh dataset will do some pre-processing and loading that not allow you to parameterized and dynamic change the connection string after publishing.

Regards,

Xiaoxin Sheng

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

Thank you for your response,

 

Yes, I enabled the incremental refresh.

I ask to support and they helps me to fix it.

It was disabled because of type Any, I changed the type into text, and the Apply Later did not take into account changes of the type of the parameters publishing the report. 

lbendlin
Super User
Super User

What's the reason for deferring the application of the changes?  Are you later planning to set the data source to incremental refresh?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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