cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rblackford
Advocate II
Advocate II

"Fields" Pane is blank, even though data appears to have loaded according to the Query Editor

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).

blankfieldscreenshot.png

 

Has anyone else experienced issues with the Amazon Redshift data source connection since it became generally available?

 

Any feedback/experiences really appreciated.

 

 

1 ACCEPTED SOLUTION
rblackford
Advocate II
Advocate II

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.

View solution in original post

1 REPLY 1
rblackford
Advocate II
Advocate II

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.

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors