Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Direct Query cannot work well with Big Query (Google)

Submitted by Anonymous on ‎12-01-2019 06:30 PM

I did minimize the data to 150M rows and 6 columns.

It work well on Power BI Desktop but cannot show and drill down on Power BI Services.

 

On the other side, I test a smaller table on Bigquery (400k rows) and it's worked.

Power BI have published the info that is direct query cannot work with Bigquery link. But my data test still work. Could anyone give me an advice for this problems

 

This is the detail message:

"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

bug report detail.PNG

 

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎12-02-2019 09:53 PM

Hi @Anonymous, 

 

From the internal trace, I found the error "Failure encountered while executing the DAX query". Please edit the report in Power BI service, remove each calculated column or measures used in visuals one by one to see which DAX might cause the issue. 

 

Best Regards,
Qiuyun Yu

Anonymous
Not applicable
‎12-02-2019 10:51 PM

Hi @v-qiuyu-msft ,

I dont use any calculated column or measures. All the table I built in Bigquery, it's no change in transform.

I just use hierarchy for drilling down the report.

After using dataset and edit the report by Power BI services, the error is still the same

 

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: 6dec4325-895d-4aab-8ba9-28cf4d1ad281
Request ID: fd1b5264-91da-1967-d94b-27df085b8799
Correlation ID: 523800a0-0299-e68b-069d-71a0df28abf4
Time: Tue Dec 03 2019 13:46:45 GMT+0700 (Giờ Đông Dương)
Service version: 13.0.11499.187
Client version: 1911.3.022
Cluster URI: https://wabi-south-east-asia-b-primary-redirect.analysis.windows.net/

bug report 2.PNG

Idea Statuses