# Power BI generated query throws illegalArgumentException on Dremio

**URL:** <https://community.cumulocity.com/t/power-bi-generated-query-throws-illegalargumentexception-on-dremio/4163>\
**Category:** Forum\
**Tags:** cumulocity\
**Created:** [October 11, 2023, 9:08am UTC](https://community.cumulocity.com/t/power-bi-generated-query-throws-illegalargumentexception-on-dremio/4163 "2023-10-11T09:08:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![simeon.mendgen](https://avatars.discourse-cdn.com/v4/letter/s/eb9ed0/32.png) [@simeon.mendgen](https://community.cumulocity.com/u/simeon.mendgen)\
**Post date:** [October 11, 2023, 9:08am UTC](https://community.cumulocity.com/t/power-bi-generated-query-throws-illegalargumentexception-on-dremio/4163/1 "2023-10-11T09:08:02Z")

</div>

#### _ **Product/components** used and **version/fix** level:_

tenant\_id.cumulocity.com UI 10.17; Backend 10.17  
Dremio. 19.11.2

#### _Detailed explanation of the problem:_

I want to explore my offloaded data using Power BI.  
Therefore i used the Power BI download on Dremio which downloads a file like (1).  
In Power BI Query Editor of Power BI Desktop it seems fine and i can see a table with the data.  
When i want to add the Data to a Graph i get an exception “_java.lang.illegalArgumentException … is not Parquet file (too small)_” (2).

For debugging tried to execute the generated query directly in dremio which gave me the same exception (3). (How can i access the log files?)

#### _Error messages / **full error** message screenshot / **log** file:_

(1) dremio download:

```auto
{
  "connections" : [ {
    "options" : { },
    "mode" : "DirectQuery",
    "details" : {
      "address" : {
        "server" : "datahub.cumulocity.com:31010",
        "schema" : "tenant_id.DataLake.storagecontainer01.tenant_id",
        "object" : "measurements_CO2Values"
      },
      "protocol" : "dremio"
    }
  } ],
  "version" : "0.1"
}

```

(2) Error in Power BI:

 ![Capture2](https://europe1.discourse-cdn.com/flex005/uploads/cumulocity/original/3X/d/4/d483d26b6a8c2227dd0d757fa60ba9f634d70e6c.png)

(3) Error in Dremio:

 ![Capture1](https://europe1.discourse-cdn.com/flex005/uploads/cumulocity/original/3X/5/5/5505a800a7681872c7136a958663a3f856857912.png)

---

<div class="post-metadata">

**Author:** ![anon53547040](https://avatars.discourse-cdn.com/v4/letter/a/c77e96/32.png) [@anon53547040](https://community.cumulocity.com/u/anon53547040)\
**Post date:** [October 11, 2023, 2:25pm UTC](https://community.cumulocity.com/t/power-bi-generated-query-throws-illegalargumentexception-on-dremio/4163/2 "2023-10-11T14:25:30Z")

</div>

Hello,  
apparently there’s a broken Parquet file in the table.  
Please raise a support request to get this fixed.

Thanks, Tim

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/flex005/user_avatar/community.cumulocity.com/system/32/31990_2.png) [@system](https://community.cumulocity.com/u/system)\
**Post date:** [April 8, 2024, 2:26pm UTC](https://community.cumulocity.com/t/power-bi-generated-query-throws-illegalargumentexception-on-dremio/4163/3 "2024-04-08T14:26:04Z")

</div>

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.