Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cannot drilldown on report - Power BI Service when using DirectQuery

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 Powe...
Need Help
venal's avatar
venal
Memorable Member
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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?