Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 51 | |
| 37 | |
| 35 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 70 | |
| 64 | |
| 39 | |
| 33 | |
| 23 |