Power BI Service - Permission Cache Hit

Dremio University
1

Hey folks!
We have Dremio working for most of our tables perfectly fine and fast. It’s been cool.
Although one specific query presents a distinct error we could not identify by ourselves.

We are running a dashboard in Power BI Service, connected to Dremio (Dremio Software). There is one query with the error: Failed to decode column sk_quote::int64 -
The query uses two datasets only. In the Planning(Raw Profile) tab I see a few other hints like:

Fragment Activate RPCs (0 ms)

“hive-odin-gold-production”.odin.ft_quotes: PERMISSION_CACHE_HIT (0 ms)
“hive-odin-gold-production”.odin.ft_quotes: CACHED_METADATA (0 ms)
“hive-odin-gold-production”.odin.dim_quote: PERMISSION_CACHE_HIT (0 ms)
“hive-odin-gold-production”.odin.dim_quote: CACHED_METADATA (0 ms)
Catalog Access for 2 Total Dataset(s): using 2 resolved key(s) (0 ms)
Catalog Access for “hive-odin-gold-production”.odin.ft_quotes (PHYSICAL_DATASET): using 1 resolved key(s) (0 ms)
Catalog Access for “hive-odin-gold-production”.odin.dim_quote (PHYSICAL_DATASET): using 1 resolved key(s) (0 ms)

Our Dremio environment is configured to use Hive-S3-Iceberg tables.

Could you give some direction on where to look to resolve the issue?

Let me know if any other log or screens would be helpful to identify the problem.

2

Hi @kleinkauff

Thanks for contacting the Dremio Cloud community!

Could you confirm if you are using Dremio Cloud? Can you also private DM me your organization ID and job ID so I can further investigate this issue?

Cindy

3

Hey Cindy!

Thanks for replying. It is Dremio OSS.

4

Hi @kleinkauff ,

Thanks for confirming.

Can you also provide the job profile of the failed job?