cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Jan2020 PBI RS version - Impala connector limitations with scheduled refresh and direct query NA?

Hi Guys,

I would like to use the Impala connector to make dashbaords for our customers automatically updated and I'm trying doing this with both Direct Query (I can create the dashboard with the Desktop but I get an error when trying to publish on PBI RS Jan2020) or at least importing data and setupping a scheduled refresh but the interface doesn't allow the this refresh functionality still...

Does that mean the unique way I can follow is really using an ODBC connection?

 

Also, I would like to setup a kerberos delegation for it but it seems there's no chance to do that with ODBC connections on data viewing.. Any advice is apprecciated here on both the subjects.

 

Power BI Report Server - Version 1.6.7364.4075 (January 2020)

Microsoft Power BI Desktop - Version: 2.76.5678.1521 64-bit (January 2020)

 

 

 

1 REPLY 1
Highlighted
New Member

Re: Jan2020 PBI RS version - Impala connector limitations with scheduled refresh and direct query NA

i tried this case too, with may2020 version, but it not working yet

not working:

    src=Impala.Database("10.60.14.1"),
    default_Schema = src{[Name="default",Kind="Schema"]}[Data],

and work with this:

    src=Odbc.DataSource("dsn=impala_dsn", [HierarchicalNavigation=true]),
    IMPALA_Database = src{[Name="IMPALA",Kind="Database"]}[Data],
    default_Schema = IMPALA_Database{[Name="default",Kind="Schema"]}[Data],

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors