Forum Discussion
View Does not Update on fabric
Hi All,
Anonymous@KevinChant
I have postgresql database connected to fabric and i am sing piplne to load tables. from those tables i have created a view but the view does not update. i do not get udated data from db. values are different.
How can i make sure data is updated in view?
pipelines are set to refresh on schedule and my expectation is view MUST update autimatically on every refresh.
i am using that view in PBI desktio as datasource.
but does not seem the case.
Hi nadia_s,
Thank you for your followup.
Please perform the following checks, which may help resolve the issue:
- Confirm the scheduled refresh in Power BI Service by navigating to the workspace and then to the dataset settings. Under Scheduled refresh, ensure the refresh frequency is set and review the refresh history.
- Verify that tables are actually refreshing in Fabric by going to Data Factory and monitoring the pipeline runs. Check activity details to confirm that rows were written. Query the table directly to validate updates using:
SELECT COUNT(*), MAX(DateColumnName) FROM [TableName];
Cross-check the view using:
SELECT TOP 10 * FROM [ViewName] ORDER BY DateColumnName DESC;
If these queries still return old data, it indicates that the pipeline did not update the target table correctly, and the view is consequently reflecting unchanged table data.
These checks will allow us to confirm both the table refresh in Fabric and the dataset refresh in Power BI, ensuring that the reports display the latest data.
We hope this information helps resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
11 Replies
v-pnaroju-msftCommunity Support
Thankyou, Shahid12523, for your response.
Hi nadia_s,We appreciate your inquiry via the Microsoft Fabric Community Forum.
Further to the suggestions provided by Shahid12523 , please follow the steps below, which may help resolve the issue:
- After the pipeline completes, run a simple query such as SELECT * FROM [ViewName] in Fabric to confirm that the view itself contains the latest table data before verifying the results in Power BI.
- Power BI reports depend on a cached semantic model or dataset. Include a semantic model refresh activity in the Fabric pipeline so that the refresh occurs automatically, or configure scheduled refresh in the Power BI service if it is not already enabled.
- There may be a short delay before the SQL endpoint reflects new table data. If you trigger a semantic model refresh immediately after a pipeline, insert a brief Wait activity before the refresh step to avoid mismatches.
For further information, please refer to the following links:
How to monitor pipeline runs - Microsoft Fabric | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Configure scheduled refresh - Power BI | Microsoft LearnWe hope that the information provided will help resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
@KevinChant
@SamsonTruong
- Shahid12523
Community Champion
A view in Fabric won’t auto-refresh unless the underlying tables are refreshed first.
Make sure your pipeline writes the latest data into the tables before the view query runs.
In Power BI Desktop, you must refresh the dataset to pull updated view data.
If using scheduled refresh, confirm it’s set up in Power BI Service, not just Fabric pipeline.
In summary: refresh pipeline → refresh dataset → view shows updated data.
Shahid12523 I am using scheduled refres. how to check it is set up in Power BI Service, not just Fabric pipeline.
- v-pnaroju-msft
Hi nadia_s,
We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.
Thank you. - v-pnaroju-msft
Hi nadia_s,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you.No the issue is still there
Pipeline runs successfully , i do not know if table refreshed.
- v-pnaroju-msft
Hi nadia_s,
We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.
Thank you. - v-pnaroju-msft
Hi nadia_s,
Thank you for your followup.
Please perform the following checks, which may help resolve the issue:
- Confirm the scheduled refresh in Power BI Service by navigating to the workspace and then to the dataset settings. Under Scheduled refresh, ensure the refresh frequency is set and review the refresh history.
- Verify that tables are actually refreshing in Fabric by going to Data Factory and monitoring the pipeline runs. Check activity details to confirm that rows were written. Query the table directly to validate updates using:
SELECT COUNT(*), MAX(DateColumnName) FROM [TableName];
Cross-check the view using:
SELECT TOP 10 * FROM [ViewName] ORDER BY DateColumnName DESC;
If these queries still return old data, it indicates that the pipeline did not update the target table correctly, and the view is consequently reflecting unchanged table data.
These checks will allow us to confirm both the table refresh in Fabric and the dataset refresh in Power BI, ensuring that the reports display the latest data.
We hope this information helps resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
- v-pnaroju-msft
Hi nadia_s,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you.
