Forum Discussion
Making changes to a semantic model with additional sources based on SQL (filter issue)
Hi Berl21
One of the suggestions is to use a composite model for this. connect to the shared semantic model by going to Get Data and selecting Power BI datasets. Then, connect to your SQL database and load the table you need into the report. After that, create a relationship between the SQL table and the relevant table in the semantic model using the common key. Once that's set up, you can use fields from your SQL table as slicers or filters to control the data shown in the report. Please refer below Document. it may helps you.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Thanks.
Hi guys, thanks for your answers!
Our semantic model was programmed by our IT to ensure a single point of truth for everyone using this model. This means Power Query is not available for the regular user, me in this case.
I need to use this model as is but with an additional filter on a common key that appears in it and my SQL. I just don't understand how it can be done outside of Power Query. If it were a filter on 3-4 entries, I could do it with a manual filter easily. But we are talking about several hundreds of entries.
Hi Berl21
One of the suggestions is to use a composite model for this. connect to the shared semantic model by going to Get Data and selecting Power BI datasets. Then, connect to your SQL database and load the table you need into the report. After that, create a relationship between the SQL table and the relevant table in the semantic model using the common key. Once that's set up, you can use fields from your SQL table as slicers or filters to control the data shown in the report. Please refer below Document. it may helps you.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Thanks.