Cannot drilldown on report - Power BI Service when using DirectQuery

[Anonymous]

Hi everyone,

Before using Direct Query I did minimize the data on Bigquery (Google) but it's still too large to import as manually.

My data around 150M rows and 7 columns

I work well on Power BI desktop but so bad on Power BI Service. It's so that errors when I drill down the charts.

Could anyone explain to me this bug and how to solve that.

Many thanks

"Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: c09b0d94-375b-40d2-aa94-4e60a3fdb91f
Request ID: 68ba037f-f850-d9bc-4ffe-9f2e810991f3
Correlation ID: 4fd11b4b-44f8-046b-4e4c-8bcf2592de09
Time: Fri Nov 29 2019 09:51:12 GMT+0700 (Giờ Đông Dương)
Service version: 13.0.11499.187
Client version: 1911.3.022

[Anonymous]

A detail message here, and need a solution from Powerbi Team

[venal]

@Anonymous 

Can you please click on the dataset >> settings >> Gateway Connection & Dataset Settings (screenshots)

[Anonymous]

@venal Is that right? 

I didnot use gateway connection because my data in the cloud (Google Cloud - Bigquery)

These remaining reports still work well and refresh daily without using gateway

Thank you alot for supports

[v-lili6-msft]

hi @Anonymous 

If you could reduce the data that use only little data to have a test again.

If you still have the issue, I would submit this as a support issue to get help from power bi support team. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Regards,

Lin

[venal]

@Anonymous 

Is it worked ealier?

Have you tried to reduce the data in the visual level by using the slicers.

Look like "Google Big Query" won't support Direct Query, please refer the link.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

[Anonymous]

Thank @venal for replying

I just test the smaller table on bigquery (400k rows) and publish to power BI services and it's work.

It seems strange to me that the Power BI said not support Bigquery on Direct Query.

I am testing to find the best way to visualize the data above, could you share me some recommends?