topic Re: Direct Query Error When Embedding Power BI Report from Linux SQL Server in Developer

Direct Query Error When Embedding Power BI Report from Linux SQL Server

rpatil0310 — Thu, 27 Nov 2025 17:44:24 GMT

Hello everyone, I'm working on embedding Power BI reports into my custom SaaS web application and have run into an issue with Direct Query mode. I've set up an on-premises gateway in standard mode and configured my data source in the Power BI portal to connect to a SQL Server hosted on a Linux VM (the same server running my SaaS app). While I can successfully create reports in Power BI Desktop on my Windows machine, connect to the SQL server remotely, and publish to the Power BI portal using Import mode without any problems, I consistently get an error when attempting to use Direct Query mode: Please find attached the copy of the error. The SQL server is accessible via remote connection and Import mode works perfectly, but I specifically need Direct Query to display real-time data in my embedded reports. Has anyone successfully configured Direct Query with an on-premises gateway connecting to a Linux-hosted SQL Server, or encountered similar issues? Any guidance would be greatly appreciated!

Re: Direct Query Error When Embedding Power BI Report from Linux SQL Server

lbendlin — Thu, 27 Nov 2025 18:51:06 GMT

Do you see the same issue on a SQL Server hosted on a Windows Server Machine? (pre-2025, ideally)

Re: Direct Query Error When Embedding Power BI Report from Linux SQL Server

v-aatheeque — Fri, 05 Dec 2025 07:03:11 GMT

Hi @rpatil0310

Just checking in to see if you were able to test with a SQL Server instance hosted on Windows Server as requested earlier?
This will help us determine whether the issue is specific to SQL Server or related to the DirectQuery + Gateway configuration.

Re: Direct Query Error When Embedding Power BI Report from Linux SQL Server

v-aatheeque — Mon, 05 Jan 2026 11:33:33 GMT

Hi @rpatil0310

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

Re: Direct Query Error When Embedding Power BI Report from Linux SQL Server

v-aatheeque — Wed, 07 Jan 2026 09:33:50 GMT

Hi @rpatil0310

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.