Coudn't load the data for this visual

[Anonymous]

Hi everyone!

Coud you help me, please? I have a Google BigQuery table that is 400 gb. I connect to it in direct query mode in Power BI. But not all visual elements are displayed. For example, this error appears:

I can't reduce the query because it contains all the sales from last year and the beginning of this year. All this information is needed to create a report in Power BI.

[Thejeswar]

Hi @Anonymous ,

This shows your query length is more than 1024K. 

One option is to reduce the size of the query by removing comments if any, as you said you can't change the query.

Think of using a CTE instead of a subquery whereby you can reduce the repetitive code.

A Simpler solution would be to create a view using this query in the source and try calling that view into Power BI just like you call tables in a select statement. Not sure if Google BugQuery allows for creation of views in it.

Hope this helps!!

[Anonymous]

Hi @Thejeswar 

I have created a view. It is updated on a schedule once a day and the result of the query is stored in a permanent table in BigQuery, to which Power BI connects.