Forum Discussion
Power BI Not Updating Big Query Data
Hi,
I've recently moved a lot of my data to Big Query and have been testing it out.
My current pipeline I'm testing is a Google Sheet into Hevo into Big Query into Power BI Desktop (Via import mode).
The initial connection and data pull worked correctly, the table in Power BI matched the table in GSheets... However, I have since updated a few cells in the GSheet and it won't update in Power BI (Still showing the same data as the initial import).
*I HAVE CONFIRMED THE DATA IN BIGQUERY IS DEFINITELY MATCHING THE GSHEET* So it seems like an issue on the Power BI end.
I have done the following and the table in Power BI is still showing the same data as when I imported it originally.
1. Refreshed it in the main desktop area as well as the "transform data" power query editor.
2. Cleared the cache and re-refreshed it.
3. Uninstalled Power BI and installed the most recent version.
4. Turned off 'Auto date/time' and 'allow data previews to download in the background' check boxes in the options. (as per this thread: https://community.powerbi.com/t5/Desktop/Power-Query-and-Power-BI-Desktop-does-not-refresh-all-data/m-p/495901)
Still not luck.
Power BI is working and pulling up to date data for my other, non BigQuery, queries (mostly SQL imports).
1 Reply
- AnonymousNot applicable
Hi Anonymous ,
Is there any error message? Are these two options checked?
Best Regards,
Jay