The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
82 | |
81 | |
37 | |
34 | |
32 |
User | Count |
---|---|
96 | |
79 | |
61 | |
51 | |
51 |