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

[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