# Connecting ODBC Apache Arrow Flight SQL to Power Bi Report Server **URL:** \ **Category:** Uncategorized\ **Created:** [August 17, 2023, 10:30am UTC](https://community.dremio.com/t/connecting-odbc-apache-arrow-flight-sql-to-power-bi-report-server/10899 "2023-08-17T10:30:43Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![rueda](https://avatars.discourse-cdn.com/v4/letter/r/cc9497/32.png) [@rueda](https://community.dremio.com/u/rueda)\ **Post date:** [August 17, 2023, 10:30am UTC](https://community.dremio.com/t/connecting-odbc-apache-arrow-flight-sql-to-power-bi-report-server/10899/1 "2023-08-17T10:30:43Z")
Hi! Dremio data sources are available in Power BI Desktop RS, but they aren’t supported when published to Power BI Report Server or when you want to work with Reporting Services (SSRS) (see links) Time ago we had the alternative of installing ODBC Dremio drivers. For example, 64-bit version to work with Power BI Report Server and 32-bit version to work with Microsoft Report Builder. But currently those drivers seem to have been replaced by ODBC Apache Arrow Flight SQL. My question: How do we now connect a Dremio data source with Power BI Report Server or Report Builder? I have tried via ODBC Driver for Arrow Flight SQL and I have not succeeded. In addition, it is indicated that it should not be used it to connect with Power BI Desktop and it does not work with 32-bit (see link or screenshot). Thanks in advance. ![Capture d’écran 2023-08-17 121954](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/1/10e0a7cad4b9aee89fb6eaf8db0084c6d7a13e60.jpeg) [ODBC Driver for Arrow Flight SQL | Dremio Documentation](https://docs.dremio.com/current/sonar/client-applications/drivers/arrow-flight-sql-odbc-driver/) [Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn](https://learn.microsoft.com/en-us/power-bi/report-server/data-sources) ---
**Author:** ![Manoj\_Raheja](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/manoj_raheja/32/5114_2.png) [@Manoj\_Raheja](https://community.dremio.com/u/Manoj_Raheja)\ **Post date:** [August 25, 2023, 3:50pm UTC](https://community.dremio.com/t/connecting-odbc-apache-arrow-flight-sql-to-power-bi-report-server/10899/3 "2023-08-25T15:50:44Z")
@rueda - for connecting to Dremio from PowerBI desktop, please use the native Dremio connector. Here are the instructions: [Connecting to Dremio from Microsoft Power BI Desktop | Dremio Documentation](https://docs.dremio.com/current/sonar/client-applications/clients/microsoft-power-bi/connecting-to-dremio-from-pbi-desktop/) Re: Microsoft Report Builder, we currently don’t support 32-bit ODBC Dremio driver. Its in our roadmap, but unfortunately we don’t have any ETA at this moment. ---
**Author:** ![rueda](https://avatars.discourse-cdn.com/v4/letter/r/cc9497/32.png) [@rueda](https://community.dremio.com/u/rueda)\ **Post date:** [August 28, 2023, 6:59am UTC](https://community.dremio.com/t/connecting-odbc-apache-arrow-flight-sql-to-power-bi-report-server/10899/4 "2023-08-28T06:59:30Z")
@Josh and @Manoj_Raheja, thank you for your answers. Connecting via the native Dremio connector with Power BI Desktop works. It is not a problem working with Power BI Service but it is with Power BI Report Server (On-Premises solution). In my case, the problem occurs because if a Power BI report is made using that connection, then it is not possible to publish the report on the report server, since Power BI Report Server does not recognize that data source: [Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn](https://learn.microsoft.com/en-us/power-bi/report-server/data-sources). That was the reason why they used ODBC instead of the native Dremio connector. I have tried to follow these steps but in my case it does not work: [How to connect Power BI to Dremio server then retrieve via ODBC – Dremio Support](https://support.dremio.com/hc/en-us/articles/15947471161883-How-to-connect-Power-BI-to-Dremio-server-then-retrieve-via-ODBC) Perhaps the problem is due to the fact that there is now some difference between the SSL connection parameters compared to the old ODBC drivers. For example, there is no “Disable hostname verification” option. ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/0/0e24951190fa97c4957deb0be33266ecf5716f73.png) ---
**Author:** ![niloc132](https://avatars.discourse-cdn.com/v4/letter/n/3ec8ea/32.png) [@niloc132](https://community.dremio.com/u/niloc132)\ **Post date:** [August 9, 2024, 4:46pm UTC](https://community.dremio.com/t/connecting-odbc-apache-arrow-flight-sql-to-power-bi-report-server/10899/5 "2024-08-09T16:46:36Z")
@Manoj_Raheja the [Connecting to Dremio from Microsoft Power BI Desktop | Dremio Documentation](https://docs.dremio.com/current/sonar/client-applications/clients/microsoft-power-bi/connecting-to-dremio-from-pbi-desktop/) link seems to be dead, do you have an updated version? ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [August 12, 2024, 2:16pm UTC](https://community.dremio.com/t/connecting-odbc-apache-arrow-flight-sql-to-power-bi-report-server/10899/6 "2024-08-12T14:16:24Z")
@niloc132 [Microsoft Power BI | Dremio Documentation](https://docs.dremio.com/current/sonar/client-applications/clients/microsoft-power-bi/)