Forum Discussion

Berl21's avatar
Berl21
Icon for Helper III rankHelper III
1 year ago
Solved

Making changes to a semantic model with additional sources based on SQL (filter issue)

Hi, I inherited a project where we need to partially rely on a semantic model. When opening it, I can edit the relationships, but I can't access Power Query. We need to filter a table available...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Berl21 

Thank you for reaching out to the Microsoft Fabric Forum Community.

speedramps Thank you for the prompt response.

Could you please provide more details about the issue, as asked by speedramps ? This will help us understand the problem better and find an appropriate solution.

Thanks.