Forum Discussion
PBI, Redshift and External Schemas.
Hi, We are using spectrum as a mechanism to store older data, whilst being able to query it using various tools (including PBI). However, we've recently found that we need to use late binding on ...
Hi j0hnsaxon,
What is the data source you want to connect? Based on my research, could you want to get data from Amazon Redshift data?
If so, you could refer to below blog:
https://powerbi.microsoft.com/en-us/blog/building-power-bi-reports-on-top-of-amazon-redshift-data/
If I misunderstand you, please let me know.
Regards,
Daniel He
Hi Daniel,
We are using the Redshift driver, however there is a component behind Redshift called Spectrum. It is a Hadoop backed database, I'm fairly certain it is a Hadoop, using Amazon's S3 file store. However, to have a view over this you need to use late binding and Power BI doesn't seem to support this, unless I'm missing something. PBI seems to think the table is empty because of this.
Thanks
John