Parameters in Power BI service

[jakubkral]

Hello,

I have problem with Power Query parameters. When i publish report online it writes me this error in semantic model.

It seems that parameters do not publish online in semantic model. When i download the copy of the file and open the Power Query i can normally see the parameters.

I tried everything. Enable load settings, filled parameters, data type to text and im without ideas.

It is interesting that for some other reports this works normal, but there are reports when this does not work, can somebody tell me what to do with this. Thank you in advance for any response.

Best regards,

J.

[v-dineshya]

Hi @jakubkral ,

Thank you for reaching out to the Microsoft Community Forum.

Please check below things to fix the issue.

1. Check Parameters Are Used in Queries. Parameters must be actively used in the data source query (in the connection string). If parameters are only defined but not used, they won’t be published.

2. Keep parameter logic simple. Avoid referencing parameters in calculated columns or measures unless absolutely necessary.

3. Use basic Data types like Text or Number. Complex types may not be supported in the Service.

4. Sometimes, recreating the parameters from scratch in a new file resolves the issue.

5. Schema changes (like renamed columns or new parameters) are not automatically synced in the Service. Refresh in Desktop and re-publish.

6. Use XMLA Endpoints or Tabular Editor for Advanced Control For enterprise-level deployments, these tools allow scripting and syncing of schema changes.

Please refer community threads and Microsoft official articles.

Solved: Parameters are not showing in powerbi Web but pres... - Microsoft Fabric Community

Solved: Parameters not working in service - Microsoft Fabric Community

Solved: Parameters aren't published to PowerBI Service - Microsoft Fabric Community

Localize date parameters in the Power BI service and Power BI Report Builder - Power BI | Microsoft ...

Edit parameter settings in the Power BI service - Power BI | Microsoft Learn

Parameters - Power Query | Microsoft Learn

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @jakubkral ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[jakubkral]

Hello,

I make it somehow working. I tried only thing a that was do the data source change over again, but this time I was carefull. First thing was to create parameters and this maybe was the problem, because it is possible, that I firstly used in the code the parameters and in the end I created them, but I do not know if this is real solution or is it just coincidence, that now this works, I did not have much time to test this.
So maybe another question here if somebody is experienced with this enough. It is possible that this could be the problem? When you first use paramater (that was not created before) and then you create them? It is possible when loading report to PowerBI Service that Power Query "remembers" the steps. It is just feeling, that when the report was going on-line it was this problem, but like I said....I am not sure about that.

[v-dineshya · Accepted solution]

Hi @jakubkral ,

Yes, creating a parameter after it’s used in Power Query steps can corrupt the internal step dependency, and Power BI Service fails to bind it properly, even though Power BI Desktop handles it without visible issues.

1. Always Create Parameters First, before referencing them in any query.

2. Make the parameter is basic type Text, Number, or True/False, Used directly in the data source connection.

3. Avoid referencing parameters in calculated columns or measures if they are not part of the actual data load.

4. In Advanced Editor, check unresolved parameter names.

5. When editing existing reports, Delete the parameter reference from the query and save. Recreate the parameter.
Re-add it to the query.

6. If Power BI Service still throws errors, try to Delete the dataset from the workspace. And Re-publishing the updated PBIX file.

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[BhavinVyas3003]

Even if parameters exist in Power Query, they won’t appear in Power BI Service unless:

1. They are used directly in a query (like filtering a table or source path).
2. They are not only referenced indirectly (e.g., via a function or unused query).

Make sure each parameter is directly referenced in a loaded query

You’ve already set the data type so make sure the parameter is actually used in a query that is loaded, not just created and left unused. Then re-publish the report.

[jakubkral]

Hello,

thanks for response. I am using it in query for loading data like this.

Source = PostgreSQL.Database(Server, Database)

Every query that I use this is set as enable to load. Or is this the wrong way of using it? Or is there any way to force the parameters?

Thank you in advance for further conversation.

[GilbertQ]

Hi @jakubkral 

This is because when you create a parameter, by default, it creates the data top as any you need to change it from any to be a specific data type, such as text number, etc. Once you do that and re upload the semantic model, you should be able to see the parameters in the service