Hello
I've been using Power BI to create tabular reports connecting to a Redshift data source for the last 2 - 3 weeks, without issue. Up until today, I was using the Amazon Redshift (Beta) connection, until it was announced this week that this connecter has become generally available (no longer in beta). I updated Power BI desktop to the latest June 2017 release.
I am now getting an issue where the "Fields" pane is blank when I connect to my view in Redshift (same database/view as before).
I have tried:
1. Restarting my computer.
2. Connecting to an excel data source (this worked fine).
3. Connecting to a different view in the same Redshift database (this actually resulted in an error telling me I was out of memory), which previously didn't happen either.
4. Trying to reproduce this issue on a colleague's computer (my colleague did not experience this issue).
Has anyone else experienced issues with the Amazon Redshift data source connection since it became generally available?
Any feedback/experiences really appreciated.
Solved! Go to Solution.
Discovered the issue... for anyone else who comes across this, it was a permissions issue. Run grant select on all tables in schema <schema name> to <username> to get the "Fields" pane to populate.
Discovered the issue... for anyone else who comes across this, it was a permissions issue. Run grant select on all tables in schema <schema name> to <username> to get the "Fields" pane to populate.
User | Count |
---|---|
114 | |
60 | |
59 | |
41 | |
40 |
User | Count |
---|---|
117 | |
66 | |
65 | |
64 | |
47 |