AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관
AWS re:Postre:Post

Athena ODBC Connector for Power BI

2

I have two catalogs in Athena - AwsDataCatalog and another named 'rds_catalog'. The 'rds_catalog' has been created to connect to RDS database instance using the Amazon Athena Federated Query connectors. I have the Simba Athena ODBC driver installed on my machine and a 'User' DSN created.

I have ensured the second catalog has been setup correctly.

When i connect to Athena using Power BI and the ODBC DSN, I see only the 'AwsDataCatalog' listed. The Other Catalog does not show up. This is so even when i set the schema to 'rds_catalog'. Makes me wonder if the driver is designed to show only the 'AwsDataCatalog' or if this is a power BI issue or something wrong that i am doing.

Appreciate any help on this issue.

주제
분석마이그레이션 및 현대화데이터베이스
태그
아마존 Athena아마존 Relational Database Service데이터베이스
언어
English
AWS-User-0620047
질문됨 2년 전1555회 조회
3개 답변
1

Go to OBDC data source configurations and change the Metadata Retrieval Method to "Proxy API" from "Auto".

Rav
답변함 2년 전
AWS
전문가
Fabrizio@AWS
검토됨 2년 전
0

I'm having this exact same issue. While the workaround that AWS-User-0620047 mentioned is sufficient for their use case, I need the DB's/tables of the 'rds_catalog' (in this example) to be displayed in the Power BI console. That way, users can see all of the different DB's/tables instead of needing to know exactly what they're querying for. So I'll echo the initial post... Is the driver designed to show only the 'AwsDataCatalog'? Or would this be an issue with power BI only being capable of displaying the AwsDataCatalog?

AWS-User-9175044
답변함 2년 전
  • AWS-User-0620047
    2년 전

    Hi,

    This behavior is not limited to Power BI - I tried with Microsoft Excel too, seeing the same behavior. I believe it could be either the Driver's limitation OR something to do with the Driver-AWS interaction.

    Regards

  • Rav
    2년 전

    Go to OBDC data source configurations and change the Metadata Retrieval Method to "Proxy API" from "Auto".

0

Hi,

As per the doc at page 91, you can use the Catalog option in your DSN.

Hope this helps

AWS
Abdel Dadouche
답변함 2년 전
  • AWS-User-0620047
    2년 전

    Thank you for your response, Abdel.

    When I created the DSN entry, I did specify the other catalog's name against 'catalog' and the relevant schema name against 'Schema'. Power BI desktop client does not show this catalog in the 'navigator' window. Only the default catalog (AwsDataCAtalog) is listed.

    I found a workaround for this issue ... on the 'From ODBC' window where one is presented and prompted to select 'DSN', there's also an 'Advanced options' selection. Expand the 'Advanced options' selection pane, and fetch desired data by giving an SQL query in the 'SQL Statement' box. Doing it this way, I was able to get data under the other catalog.

    Cheers

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠