# The table has no visible columns and cannot be queried in Power BI

**URL:** <https://community.dremio.com/t/the-table-has-no-visible-columns-and-cannot-be-queried-in-power-bi/2096>\
**Category:** Uncategorized\
**Created:** [October 25, 2018, 9:24pm UTC](https://community.dremio.com/t/the-table-has-no-visible-columns-and-cannot-be-queried-in-power-bi/2096 "2018-10-25T21:24:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![michel.pureza](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/michel.pureza/32/982_2.png) [@michel.pureza](https://community.dremio.com/u/michel.pureza)\
**Post date:** [October 25, 2018, 9:24pm UTC](https://community.dremio.com/t/the-table-has-no-visible-columns-and-cannot-be-queried-in-power-bi/2096/1 "2018-10-25T21:24:15Z")

</div>

Hi guys,

I’m new to the dremio and I’m trying to do an integration between power bi.  
I’ve already imported my data into the dremio community and everything looks ok. Also, I can connect the power bi in the dremio.

 ![tempsnip](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/7/75e1aa9ee115aa85ad71d4c6f183b03acb3baa1b.png) But when I select my tables are physical or virtual I can not see my data and I get the following error: “DataSource.Error: The table has no visible columns and can not be queried.”  
What can be the cause of this problem?

---

<div class="post-metadata">

**Author:** ![kelly](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/kelly/32/11_2.png) [@kelly](https://community.dremio.com/u/kelly)\
**Post date:** [October 25, 2018, 9:27pm UTC](https://community.dremio.com/t/the-table-has-no-visible-columns-and-cannot-be-queried-in-power-bi/2096/2 "2018-10-25T21:27:07Z")

</div>

That’s very odd.

Is there a job that is run in Dremio? What is the data source?

---

<div class="post-metadata">

**Author:** ![michel.pureza](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/michel.pureza/32/982_2.png) [@michel.pureza](https://community.dremio.com/u/michel.pureza)\
**Post date:** [October 29, 2018, 5:56pm UTC](https://community.dremio.com/t/the-table-has-no-visible-columns-and-cannot-be-queried-in-power-bi/2096/3 "2018-10-29T17:56:22Z")

</div>

Hello  
So, I do not have any jobs in the drem.  
The data source is a locally stored worksheet.