Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
When we publish it, we click on “Apply later” button.
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
Solved! Go to 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.
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
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.
What's the reason for deferring the application of the changes? Are you later planning to set the data source to incremental refresh?
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |