Forum Discussion

dpombal's avatar
dpombal
Post Partisan
6 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 Anonymous 

 

Did you get any further on this?

 

Best,

 

Ali A

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous I still struggle with these errors. What seems to help though is to not use views that require a lot of processing but rather materialize them to tables in BQ and run the report on tables.

 

Let me know if you find any other solutions to this.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

     

    Ok.


    We have tested with using Simba ODBC driver and a Gateway and that seems to give us more stable performance. What is also worth mentioning is that this gives the opportunity to also write direct SQL queries with joins, renaming etc. directly back to the db (native query).

     

    Best,

     

    Ali A