View changes are not reflecting on Reporting

[akkibuddy7]

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?

[nilendraFabric · Accepted solution]

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 table

if this is helpful please accept the solution and give kudos

[akkibuddy7 · Accepted solution]

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

[v-achippa]

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

[v-achippa]

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

[v-achippa]

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

[nilendraFabric · Accepted solution]

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 table

if this is helpful please accept the solution and give kudos