PBI, Redshift and External Schemas.

[j0hnsaxon]

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 views and anything spectrum! It seems that PBI doesn't support them as it cannot recognise the structure of the data. We can't even choose the raw spectrum tables in the hope of running an Append Transform.

The suggestion to use ODBC doesn't work with masses of data as it seems to work in import mode another option I've found is DataDirect by Progress, which I'm in the process of testing.

I was wondering how others have managed to display masses of data from external tables in Redshift.

Thanks

John

[v-danhe-msft]

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

[j0hnsaxon]

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