DirectQuery and Power BI Server

[anthony_snk]

I have a WareHouse with redshift and I want to publish a report or export an repor with Power bi server, but I got an errror when I tried to save the report with DirectQuery, I tried to save the  same report on Power bi server and this option worked, I only had to put the origin data user and password, but in Power BI server I could not find the option, the error that the software gave me It was something like this " Your version in not compatible with this version of power bi server (I have may 2020 version, server and desktop PBI)". 
After that I tried to save the same report without directQuery and It was working?

The question is.... Is it posible to connect Power Bi server with a direct query? 
or It's a limit of software 

Thanks!

[KBO · Accepted solution]

Hi @anthony_snk ,

redshift istn't supported in DQ: https://docs.microsoft.com/de-de/power-bi/report-server/data-sources

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!