Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.