Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

Problems with data refresh in the service

Hello everyone I have a huge problem. I publish a report to the service with data updated to date. Upload perfectly: see image When you update the data automatically, the data reverts t...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

Hello, thank you for your reply.

On the desktop, all reports are updated normally and uploaded well and with updated data.

The update is carried out well in the service but the data all returns to February 19, in all the reports that connect to that database.

I've already tried to make a new report and it does the same. I upload it with data to today and when updated it goes back to February 19.

I don't think there are a filters in Power Query because this happens with 10 different files.

Is there a way in Power Query to place a filter that affects all reports?

5. And obviously it does not bring the recent data, how can I verify that ebel service?

Thank you very much again.

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Syndicate_Admin ,

  1. Power Query does not have a built-in feature to apply a global filter across multiple reports. However, you can achieve a similar effect by creating a common table with the filter criteria and linking this table to your other tables in each report.
  2. Check if the ebel service is bringing in the latest data.

Ensure that the on-premises data gateway is properly configured and fetching new data. If not, restarting the gateway might help.

Power BI Service may cache old data, causing issues. Try clearing the cache or manually refreshing the dataset to resolve this.

You can also test roles in Power BI Service to verify if data is being fetched correctly. Navigate to the workspace, select the dataset, and use the "Test data as role" option to view data as a specific user or role.

 

Although you mentioned there are no filters in Power Query, it might be beneficial to revisit the query settings to ensure there are no hidden transformations or filters affecting the data. If necessary, create a new query from scratch to check if the issue persists.

 

 

For further investigation, kindly raise a support ticket using the link provided below. This will help ensure the issue is thoroughly addressed.

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

 

Regards,

Yugandhar.