Power Bi Report Server and Amazon Redshift

gregboothdelt — Thu, 09 Sep 2021 22:56:30 GMT

We are using a power BI report server for internal comsumption of reports.

We have a new data source in Amazon Redshift. We are planning to write reports with redshift as the data source and deploy them to our on-premise report server.

However, looking at the page

https://docs.microsoft.com/en-us/power-bi/report-server/data-sources this says that

"Some data sources are available in Power BI Desktop for Power BI Report Server, but aren't supported when published to Power BI Report Server". In the list of supported data sources, it says that Amazon Redshift is supported for "Cached Data", but not for Scheduled Refresh and Live/Direct Query.

What does "Cached Data" mean ? Is it the data in the report from when you last refrehed it in power bi desktop only ? i.e. when you upload the report to the report sever, is there then no way to refresh the data ?

Re: Power Bi Report Server and Amazon Redshift

d_gosbell — Fri, 10 Sep 2021 05:03:41 GMT

gregboothdelt wrote:

What does "Cached Data" mean ? Is it the data in the report from when you last refrehed it in power bi desktop only

Yes, this is exactly what this means - "the data in the report from when you last refrehed it in power bi desktop only"

gregboothdelt wrote:

i.e. when you upload the report to the report sever, is there then no way to refresh the data ?

This is correct. The only way to refresh the data is to manually refresh it in Desktop then re-upload it to Report Server.

topic Power Bi Report Server and Amazon Redshift in Report Server

Power Bi Report Server and Amazon Redshift

Re: Power Bi Report Server and Amazon Redshift