DirectQuery and Power BI Server

Anonymous — Fri, 28 Aug 2020 23:41:01 GMT

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!

Re: DirectQuery and Power BI Server

KBO — Sat, 29 Aug 2020 07:50:11 GMT

Hi Anonymous ,

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!

topic Re: DirectQuery and Power BI Server in Report Server

DirectQuery and Power BI Server

Re: DirectQuery and Power BI Server