Hi,
I was not able to find an adequate solution for this problem so I hope you can help me out.
The problem is only occuring on the desktop version of PowerBI (Version: 2.87.1061.0 64-bit (November 2020))
With the previous version of the desktop version (we had the September version) this problem did not occur.
The data we try to load may have increased as well (times 2), but is heavily filtered. Also, the report runs smoothly on the client's PowerBI server.
This is the situation:
We are having Big Query connected to PowerBI (method = import) and we are making already use of the allowLargeResults=true parameter.
Source = GoogleBigQuery.Database([allowLargeResults=true]),
The Data we have can be seen as event data, meaning we have a timestamp, event_id and value as columns.
From this selection, we immedeatly filter/select two event_ids over their full time track and we remove all other columns. So far, this part goes succesful.
Subsequently we apply a pivot, so we would have the 2 event_ids as column names and their values as records. This is where I get the error:
ODBC: ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: Response too large
How can we overcome this, It is remarkable that this did not happen in the past, also, the report is working smooth on the PowerBI server side...
I am looking forward to your response, If you need further information let me know
Olivier
