Forum Discussion
View changes are not reflecting on Reporting
I have use case where I'm using S3 shortcut table but fabric consider this as live connection hence I cant modify anything on table like adding new column or rename it. To solve this issue I'm creating Views on top of fabric shortcut table and linked that View to semantic model for reporting. but Whenever I try to alter/update the View it doesn't reflect changes semantic model/reporting side even after Refreshing it. Any idea how to proceed?
Hello akkibuddy7
When using S3 shortcut tables in Microsoft Fabric, views built on these tables may not automatically propagate schema changes to the semantic model due to Fabric’s read-only handling of shortcuts and caching behavior. Here’s how to resolve this:
For stable reporting:
1. Create shortcut → Raw data (S3)
2. Build view → Initial transformations
3. Materialize → Managed Delta table
4. Connect → Semantic model to managed tableif this is helpful please accept the solution and give kudos
Found the solution,
We have to Click Refresh icon in Semantic Model and then all the alter Views data will be visible in semantic model as well as Report side-
Semantic Model > Edit Tables > click Resresh icon > Confrim
NOTE : Don't click any table or view checkbox when in Edit Table option except Refresh Icon
5 Replies
Hello akkibuddy7
When using S3 shortcut tables in Microsoft Fabric, views built on these tables may not automatically propagate schema changes to the semantic model due to Fabric’s read-only handling of shortcuts and caching behavior. Here’s how to resolve this:
For stable reporting:
1. Create shortcut → Raw data (S3)
2. Build view → Initial transformations
3. Materialize → Managed Delta table
4. Connect → Semantic model to managed tableif this is helpful please accept the solution and give kudos
Hi akkibuddy7,
Thank you for reaching out to Microsoft Fabric Community.
Thank you nilendraFabric for your prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
Hi @akkibuddy7,
We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
Hi @akkibuddy7,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
Found the solution,
We have to Click Refresh icon in Semantic Model and then all the alter Views data will be visible in semantic model as well as Report side-
Semantic Model > Edit Tables > click Resresh icon > Confrim
NOTE : Don't click any table or view checkbox when in Edit Table option except Refresh Icon
