Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I am working on semantic model and when we import more then one sematic model in power bi desktop it fetch as direct query
and i am using field parameters which is not working properly because of direct query mode why it so ,
how to resolve same .
Thanks
Solved! Go to Solution.
Hi @Bhumika9 ,
You mean that your data source is a semantic model and is currently in direct connect mode, right? According to the documentation, it is not possible to create parameters in a live connected data source. However, if you use DirectQuery with Power BI Semantic Model and Analysis Services, you can add a local model to create field parameters. See the status bar in the lower right corner of Power BI Desktop. Please select "Make changes to this model" in the status bar. Then add a local model to create the field parameters.
For more details, please refer: Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Bhumika9 ,
You mean that your data source is a semantic model and is currently in direct connect mode, right? According to the documentation, it is not possible to create parameters in a live connected data source. However, if you use DirectQuery with Power BI Semantic Model and Analysis Services, you can add a local model to create field parameters. See the status bar in the lower right corner of Power BI Desktop. Please select "Make changes to this model" in the status bar. Then add a local model to create the field parameters.
For more details, please refer: Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
72 | |
67 | |
51 | |
38 | |
26 |
User | Count |
---|---|
88 | |
52 | |
45 | |
39 | |
38 |