topic Power BI Report Server and SQL Developer in Report Server

Power BI Report Server and SQL Developer

Pbiguy4u — Tue, 21 Feb 2023 05:05:53 GMT

Hey I'm new to the Business Intelligence community. I'm currently setting up Power BI Report Server for an organization. However they currently use SQL Developer instead of SQL Server. My question is, is it possible and/or as straight forward to connect to SQL Dev as it is to SQL Server, or will I be needing intermediary tools of some sort? Thank you.

Re: Power BI Report Server and SQL Developer

R1k91 — Tue, 21 Feb 2023 16:08:48 GMT

SQL Server Developer Edition it's like an Enterprise edition.

Editions and supported features of SQL Server 2022 - SQL Server | Microsoft Learn

you don't need any magic to work with it

Re: Power BI Report Server and SQL Developer

JPM — Wed, 22 Feb 2023 08:58:03 GMT

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database

remember to install the ODAC components on the report server as well as any client machines with Power BI Desktop installed