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! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

Error PARTTIONTIME

‎07-07-2023 08:01 AM

Hi everyone, me again. Sorry for so many posts, I'm new. Does anyone know about this error?

 

DataSource.Error: ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: Cannot query over table '' without a filter over column(s) '_PARTITION_LOAD_TIME', '_PARTITIONDATE', '_PARTITIONTIME' that can be used for partition elimination

Detalles
DataSourceKind = GoogleBigQuery
DataSourcePath = GoogleBigQuery
OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {})
Labels:
Message 1 of 1
222 Views
0
0 REPLIES 0

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All