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 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Berl21 

Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted  If yes, marking the relevant solution would be awesome for others who might run into the same thing.