Modelling Parameters in Power BI with Semantic model connection

[tvandorfffy]

Hi there,

When I am connecting to a semantic model (e.g. created in a Lakehouse), the Parameters button in Modelling greys out:

Is there way to use parameters in a situation like this, if yes, where can it be defined?

I have found only a workaround: if I use "Make changes to this model", then a local model added to the .pbix file, but the connection will change to DirectQuery. And also this is a permanent change, there is no way to revert back.

Is this really the only way? Is there any disadvantage to switch to DirectQuery in this situation?

Many thanks,

sorry for asking a lot of questions.

Tamas

[jaryszek]

Hi Guys,

new idea for it:
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Skip-Credential-Validation-for-Queries-Exclud...

Please vote!

It means that you can exclude query to be refreshed not only in power bi desktop - also within power bi service without failing because of data source credentials. 

Best,
Jacek

[Anonymous · Accepted solution]

Hi @tvandorfffy

Using parameters with semantic models directly in Power BI Desktop does have limitations, especially when the connection is not in DirectQuery mode. Parameters in Power BI are mainly used to handle queries that can be modified directly in Power BI Desktop, which is why you may find that the Parameters button is disabled when connecting to a semantic model in a way that does not allow local query modification.

Here are two links detailing the differences between the two modes, along with example applications. Hope it helps.

Power Up your BI with Microsoft Power BI and Lakehouse in Azure Databricks: part 1 - Essentials - Mi...

Power Up your BI with Microsoft Power BI and Lakehouse in Azure Databricks: part 2 - Tuning Power BI...

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tvandorfffy]

Thank you for your response!