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

[Berl21]

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 in the semantic model down to a specific number of rows, based on a SQL statement from another source. Normally I would use Power Query to create this filter and reduce the results to the rows I need. But in this case, I am at a loss as how to filter out results.

Is there a way to go around it?

Thanks,

Pauline.

[v-priyankata]

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.

[v-priyankata]

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.

[Berl21]

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.

[v-priyankata]

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.

[v-priyankata]

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.

[speedramps]

Hi Pauline

I want to help you but your description is too vague. Please provide more info.

Why can you edit relationships but can't access Power Query?  

Is it Direct Query?
Can you refresh the data as it stands. Do you get an error message?

Do you not have securitry access to the data source?

You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming

* Please DO give a simple non-technical functional description of what you want
* Keep it simple and break large projects into smaller questions and ask just one question per ticket.
* Rename columns to user friendly names. Avoid your own system jargon that we may not understand.
* Most importantly please provide example input data as table text (not a screen print) so helpers can import the data to build a solution for you. (Learn how to share data below)
* Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
* Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
* Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
* Remember not to share private data ... we don't want you to get into trouble. ‌‌
* Please click the thumbs up button for these helpful hints and tips. Thank you.

Learn how to attach data in the forum using OneDrive:-
* Save your file in a OneDrive folder
* Right click on the file and click the “Share” blue cloud icon
* Click the bottom “Copy” button
* Click” Anyone with link can edit”
* Click “Can Edit”
* Click “Can View”
* Click “Apply” button
* Click “Copy”
* Paste the generated link via the forum, email, chat, or any other method.
* Helpers can then download your data, build a solution and share it back.

Learn how to attach data in the forum using Dropbox:-
1. Open Dropbox: Access the Dropbox folder on your computer or through the Dropbox web interface.
2. Select File/Folder: Find the file or folder you want to share.
3. Click Share (or Get Link): Look for a "Share" option or a similar "Get Link" option.
4. Choose Permissions: Decide whether to allow "view only" or "view and download" access.
5. Copy and Share: Copy the generated link and share it with anyone via the forum, email, chat, or any other method.