Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
@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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
5 | |
3 |