Forum Discussion
edsonfajilagot
8 years agoNew Member
Error in accessing redshift spectrum (external table)
Hi guys, Any success in getting data from redshift spectrum? I'm getting the error: DataSource.Error: The table has no visible columns and cannot be queried. From aws documentation, https://d...
Anonymous
6 years agoNot applicable
Hello,
I still have the same error. I also tried to create a view around the external table but it still fails. Below are the error details.
Feedback Type:
Frown (Error)
Timestamp:
2019-11-20T14:16:11.2215250Z
Local Time:
2019-11-20T16:16:11.2215250+02:00
Session ID:
81f7d9ba-90ec-44fd-85bd-8c01f4b90a3c
Release:
November 2019
Product Version:
2.75.5649.582 (19.11) (x64)
OS Version:
Microsoft Windows NT 10.0.18362.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 528040]
Peak Virtual Memory:
38.3 GB
Private Memory:
544 MB
Peak Working Set:
702 MB
IE Version:
11.388.18362.0
User ID:
b22a3ce1-8cc5-4140-a640-90212e8cd6c1
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Snapshot Trace Logs:
C:\Users\youssef.youssef\Microsoft\Power BI Desktop Store App\FrownSnapShot1286604497.zip
Model Default Mode:
DirectQuery
Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_userFavoriteResourcePackagesEnabled
PBI_personalVisualizationPaneEnabled
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_decompositionTree
Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_realTimeRefresh
PBI_QueryDiagnostics
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Anonymous
6 years agoNot applicable
Turned out that the data types used in Athena must be one of the supported data types in Redshift
https://docs.aws.amazon.com/redshift/latest/dg/c_Supported_data_types.html
Changing strings to varchar and integers to decimal data types got the direct queries working in Power BI against Redshift spectrum.