BigQuery data doesn't reflect in the report correctly

[Tani4ka]

My report successfully refreshed on a daily basis but the data from BigQuery doesn't show in the report with the correct latest date. When refreshed via desktop its being picked up correctly.

it started happening 2 weeks ago only and was working just fine before.

Any ideas what could cause this behaviour?

Thanks

[Tani4ka]

Hello. I am working with our Org Admin on this - the ticket is yet to be raised but hoping this week as the issue still persists.

[v-karpurapud]

Hi @Tani4ka 

We are following up once again regarding your query. If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-karpurapud]

Hi @Tani4ka 

Thanks for the update. Hope your issue gets resolved soon. when it does, please share the insights here and mark it or any other helpful answer 'Accept as Solution', which will help others with similar queries.

Thank you.

[v-karpurapud]

Hi @Tani4ka 

Thank you for reaching out to the Microsoft Fabric Community Forum.

Regarding the issue you're experiencing with BigQuery data not reflecting the latest values in your Power BI report after a scheduled refresh, please consider the following points:
 

There might be timezone discrepancy occurs. If your query or view in BigQuery relies on CURRENT_DATE(), CURRENT_TIMESTAMP() or similar, then:

   Power BI Desktop (e.g., in PST) evaluates CURRENT_DATE() as April 13

   Power BI Service (UTC) might still see April 12 during the early part of the day

If it is the case, then update query or view in BigQuery to use a fixed timezone using CURRENT_DATE()(or your local timezone).

Power BI Service may cache query results, preventing reports from showing the latest data even after a refresh. Refresh manually on the report page and verify if the latest date now appears or not.

Additionally , note that Power BI Desktop and Service can fold queries differently, especially for complex transformations in Power Query. Ensure that transformations are optimized to fold all the way to BigQuery.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank You
 

[Tani4ka]

I'm afraid it is not the case. The latest date i see in the report is 4th April but in GBQ is 9th April. I do not rely on the CURRENT_DATE() . With desktop version i see the 9th stright away and when published as well. But in order to see the next day again (lets say the 10th tomorrow) i have to refresh tomorrow in the desktop and republish. Any other suggestions? Would be very gratfull. Thanks. 

[v-karpurapud]

Hi @Tani4ka 

Despite the scheduled refresh running successfully, the underlying data is not updating in the Power BI Service.

If the dataset is in Import Mode, Power BI loads a snapshot of data at the time of refresh. If the service refresh is not actually fetching new data from BigQuery, stale data will persist.

When you refresh in Desktop and publish, the refreshed model is uploaded to the Service  that’s why it shows the latest date. But the Service refresh isn't truly refreshing the model.Try re-authenticating the Google BigQuery connection, even if it appears valid. Then refresh it in service. Check whether it resolves the issue or not.

If this post helps, kindly mark it as Accepted Solution.

Thank You!

[Tani4ka]

I'm fraid it did not resolve the problem for me

[v-karpurapud · Accepted solution]

Hi @Tani4ka 

Since we have ruled out common causes such as credential re-authentication, dataset refresh behavior, and discrepancies between Power BI Desktop and Service, and the issue persists, it seems a deeper investigation into your specific environment and dataset configuration is necessary.

I recommend raising a support ticket with Microsoft for a more detailed analysis. The support team can access backend logs and provide targeted assistance to resolve the issue.

You can submit a ticket through the Microsoft Power BI Support Portal:

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

Thank you!

[v-karpurapud]

Hi @Tani4ka 

Could you please confirm if you have raised the support ticket and if the issue has been resolved after raising a support ticket? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you !