Forum Discussion

dpombal's avatar
dpombal
Icon for Post Partisan rankPost Partisan
7 years ago

Error on refresh dataset with Google Big Query - large table

Hi all, I am trying to refresh a report in powerbi service with data from Google Big query, in desktop it takes 30-40 minutes. When moving to service , below error appears. This table contains 47 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi dpombal Anonymous Anonymous  v-xuding-msft 

 

interesting topic... Im facing related issues. Locally, I am developing a PBI model using Simba ODBC to connect to BigQuery. Query folding on the navigation steps seems alsoto work (option on right click not grayed out). When then setting up (date/time) parameters for a incremental refresh on my multimillion rows fact table, it starts import first 1000 rows (at least Power BI says so). However, "1000 rows imported" is the maximum it gets. Seems like the filter parameter is not being folded to BigQuery... Fortunately, I can cancel it. Unfortunately, it even solidifies my theory that there is no query folding and communication between PowerBI and BigQuery happening...

 

Do you guys have any suggestions? Am I missing a step? Thanks in advance.

 

Cheers,

Eli