Subset of actual semantic model to be joined with new excel file on desktop

[Y_Bobby]

Hi, 

I got a scenario where a report is generated through Q&A in Power BI service. The report which has subset data of actual semantic model needs to be joined with new file which is on desktop or share point. Not through export but the subset should be connected with actual semantic model instead of creating new model.

Please suggest on above

[v-pagayam-msft]

Hi @Y_Bobby ,
I wanted to follow up on our previous suggestions regarding the issue you are facing. We would like to hear back from you to ensure we can assist you further. If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. 
Thank you.

[v-pagayam-msft]

Hi @Y_Bobby ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by us. I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.

Thank you

[v-pagayam-msft]

Hi @Y_Bobby ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[v-pagayam-msft · Accepted solution]

Hi @Y_Bobby ,
Thank you for reaching out to us on Microsoft FAbric Community Forum!

Since Q&A in Power BI creates a temporary subset from a semantic model, it may not be directly joined with external files. However, you can replicate that subset and join it with your file using Power BI Desktop. Just connect to the original semantic model using Get Data > Power BI Datasets (with Build permission), then bring in your new file from SharePoint or desktop. Create relationships using common keys, apply the same filters used in your Q&A visual to recreate the subset, and build your report. This approach keeps your connection to the semantic model without exporting data or creating a new model. Then, publish the report to the service.
Refer the below link for more information.
Limitations of Power BI Q&A - Power BI | Microsoft Learn

Hope this helps.If so,consider accept it as solution.

Regards,
Pallavi.