# \[Solved\] Using Power BI Service with Dremio **URL:** \ **Category:** Uncategorized\ **Created:** [November 30, 2018, 3:20pm UTC](https://community.dremio.com/t/solved-using-power-bi-service-with-dremio/2346 "2018-11-30T15:20:37Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![pollyannaogoncalves](https://avatars.discourse-cdn.com/v4/letter/p/ec9cab/32.png) [@pollyannaogoncalves](https://community.dremio.com/u/pollyannaogoncalves)\ **Post date:** [November 30, 2018, 3:20pm UTC](https://community.dremio.com/t/solved-using-power-bi-service-with-dremio/2346/1 "2018-11-30T15:20:37Z")
Hi everyone! I was wondering if there are any way to connect Dremio with Power BI Service/Pro. I’ve already tested in Power BI Desktop with Dremio Connector (Beta), but it seems that it doesn’t work on the online version. Since a ODBC connection seems not to be a solution (read in some posts here that it’s not possible yet). What are the options? Thanks! ---
**Author:** ![HappyCowboy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/happycowboy/32/564_2.png) [@HappyCowboy](https://community.dremio.com/u/HappyCowboy)\ **Post date:** [November 30, 2018, 3:52pm UTC](https://community.dremio.com/t/solved-using-power-bi-service-with-dremio/2346/2 "2018-11-30T15:52:35Z")
I believe it’s possible with the Microsoft Gateway. [https://powerbi.microsoft.com/en-us/gateway/](https://powerbi.microsoft.com/en-us/gateway/) ---
**Author:** ![pollyannaogoncalves](https://avatars.discourse-cdn.com/v4/letter/p/ec9cab/32.png) [@pollyannaogoncalves](https://community.dremio.com/u/pollyannaogoncalves)\ **Post date:** [November 30, 2018, 4:07pm UTC](https://community.dremio.com/t/solved-using-power-bi-service-with-dremio/2346/3 "2018-11-30T16:07:04Z")
The problme is that Dremio doesn’t appear in the source types dropdown menu when trying to add it in the Gateway ![Sem%20t%C3%ADtulo](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/c/c1e74219921a66cbac168b2de4afd05485d5523f.png) ---
**Author:** ![HappyCowboy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/happycowboy/32/564_2.png) [@HappyCowboy](https://community.dremio.com/u/HappyCowboy)\ **Post date:** [November 30, 2018, 4:25pm UTC](https://community.dremio.com/t/solved-using-power-bi-service-with-dremio/2346/4 "2018-11-30T16:25:24Z")
Once you configure the local gateway with the dremio connector you can publish to PBI Online and direct query to Dremio. ---
**Author:** ![jason](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jason/32/3129_2.png) [@jason](https://community.dremio.com/u/jason)\ **Post date:** [December 1, 2018, 1:35am UTC](https://community.dremio.com/t/solved-using-power-bi-service-with-dremio/2346/5 "2018-12-01T01:35:26Z")
couple things it might be: 1. did you enable custom data connectors for the gateway? note all gateways in the cluster have the July 2018 update release or later for this option to be available ![](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/3/3ffb40c0c220e7050c3e46cc5d9c1f94382c7cc4.png) 1. did you copy Dremio.mez file in C:\Program Files\Dremio Connector\Microsoft Power BI after ODBC driver installation to the location you specified for where to store the custom connector files? ---
**Author:** ![pollyannaogoncalves](https://avatars.discourse-cdn.com/v4/letter/p/ec9cab/32.png) [@pollyannaogoncalves](https://community.dremio.com/u/pollyannaogoncalves)\ **Post date:** [December 3, 2018, 12:52pm UTC](https://community.dremio.com/t/solved-using-power-bi-service-with-dremio/2346/6 "2018-12-03T12:52:17Z")
Thanks for the anwser Jason, Yes, the Dremio.mez is already on the Power BI Desktop Custom Connectors folder. This checkbox you showed on PBI Service is not present in mine (see the image below). Maybe this is because I’m using the On-premises Data Gateway? ![Sem%20t%C3%ADtulo](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/4/4c57f9bc8ace1eb7165510ab9f4738fc649fd9e2.png) ---
**Author:** ![jason](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jason/32/3129_2.png) [@jason](https://community.dremio.com/u/jason)\ **Post date:** [December 3, 2018, 7:25pm UTC](https://community.dremio.com/t/solved-using-power-bi-service-with-dremio/2346/7 "2018-12-03T19:25:31Z")
@pollyannaogoncalves Is the gateway version you have installed July 2018 update or later? ---
**Author:** ![pollyannaogoncalves](https://avatars.discourse-cdn.com/v4/letter/p/ec9cab/32.png) [@pollyannaogoncalves](https://community.dremio.com/u/pollyannaogoncalves)\ **Post date:** [December 10, 2018, 11:26am UTC](https://community.dremio.com/t/solved-using-power-bi-service-with-dremio/2346/8 "2018-12-10T11:26:56Z")
This was the trick! Now, the Dremio option appears on the connectors option on Power BI service. I’m gonna test some datasets refreshs…thanl you very much!