Forum Discussion
Smart Narrative Power BI Live Semantic Model
Does the smart narrative (non-copilot) work with measures (e.g. a measure called "in_chid_not_in_parent") locally created in a powerbi (child.pbix {non-composite model}) that is connected to a live semantic model (parent.pbix )?
In other words, Is the smart narrative (non-copilot) capable of displaying measures (created on-the-fly) where the pbix {non-composite model} is connected to Power BI live semantic model?
if no for above, what is the workaround? do I need to define all my measures in parent.pbix in order for them to show up all {non-composite model} child.pbix for the smart narrative to display?
Thank you in advance.
Hi smpa01
No, the Smart Narrative (non-Copilot) in Power BI does not work with measures created locally in a child PBIX file when it is connected to a live semantic model (parent PBIX) in a non-composite model setup. Since the child PBIX is in a Live Connection mode, it acts as a thin report and does not store or recognize locally created measures for Smart Narrative. As a workaround, you need to define all required measures in the parent PBIX (semantic model) so they are available for reporting in the child PBIX. Alternatively, if you need local measures, you must enable a DirectQuery for PBI dataset and AS (composite model) instead of a pure Live Connection, which allows defining additional measures in the child PBIX. However, this approach may have performance considerations.
8 Replies
Hi smpa01
No, the Smart Narrative (non-Copilot) in Power BI does not work with measures created locally in a child PBIX file when it is connected to a live semantic model (parent PBIX) in a non-composite model setup. Since the child PBIX is in a Live Connection mode, it acts as a thin report and does not store or recognize locally created measures for Smart Narrative. As a workaround, you need to define all required measures in the parent PBIX (semantic model) so they are available for reporting in the child PBIX. Alternatively, if you need local measures, you must enable a DirectQuery for PBI dataset and AS (composite model) instead of a pure Live Connection, which allows defining additional measures in the child PBIX. However, this approach may have performance considerations.
I have business scenarios that dictates creating children with locally defined measures of a single parent. I have several such example
1:18, 1:5, 1:4, so on and so forth.
It is simply not possible to define all the measures in th parent as and when these children emerge out of business req so that I can satisfy the smart narrative.
The business scenario is inevitable so as taking advantage of smart narrative. If an AS lets me do that, I can always do select 1 from a DB on a sql connector so that I can locally define measure from smart narrative to be happy. Now, woth this arrangement I never need to refresh the composite model as the AS rule dictates the live model gets refreshed when parent is refreshed and I don't need to refresh the sql tbl who is on import mode.
Now, with this arrangement above, will the locally created measure still work in smart narrative? That is the big Q
Hi smpa01
In your scenario, where you have a live connection to a parent semantic model and are defining local measures in the child model, the Smart Narrative (non-Copilot) feature does not support locally defined measures in a non-composite model. This is because Smart Narrative relies on the semantic model structure rather than dynamically created local measures.
Your workaround using an import-mode SQL table to force a composite model does enable local measures, but the challenge remains whether Smart Narrative can recognize them. In composite models, locally created measures should work with Smart Narrative if they are based on imported tables or fully independent calculations. However, if they reference the live connection tables from the parent semantic model, Smart Narrative may not detect them properly.
To ensure Smart Narrative works, you might have to fully define your measures in the parent model. If that’s not feasible, an alternative approach is creating calculated tables in the child model based on the local measures and using those as a source.
Hi smpa01,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you are trying to use Smart Narrative(non-Copilot) in a child PBIX file that has a Live Connection to a parent semantic model(parent PBIX). As Poojara_D12 gave response to your queries and if it solves your issues then please mark the helpful response as solution so that other community members can get through their similar issues.
I would also take a moment to thank Poojara_D12, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
Anonymous
Happy to help 🙂
If possible consider subscribing my Youtube channel for basic to advance power BI and SQL related content, link given below.
Hi smpa01,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.I am yet to test this one out with my PROD element
Hi smpa01,
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. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
