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

I am struggling with the same error type. Did you find out what the problem was? I have had both Google and MS looking at this without any luck...

  • 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