cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DaveH Frequent Visitor
Frequent Visitor

USE `MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2` being sent to Impala via Direct Query

Hi,

 

I have connected to Impala with a Direct Query connection.  When I do, I see the following query in the Impala query log on a regular basis during the use of PowerBi (ie its not just a one off when the connection is created but, over an over, multiple times per minute at times).

 

 

USE `MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2`

 

This of course fails with a permissions error.  The database doesn't actually exist in Impala.

 

This is happening with other users as well.

 

Why is PowerBI trying to connect to this database that doesn't exist?

 

Why does it not get the message after the first failure?  Smiley Wink

 

Can we do something (other than create a DB that probably isn't going to be what PowerBI expects anyway) to prevent this happening?  It does make a mess of the query log and is putting a lot of entries into our Denied Access audit logs that we would rather not have to filter away.

 

Thanks

Dave.

5 REPLIES 5
DaveH Frequent Visitor
Frequent Visitor

USE `MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2` being sent to Impala on Direct Query

Hi,

 

I have connected PowerBI to Impala using the built in Impala connectory (Direct Query connection).  Whenever I do this I am seeing an attempt from my user ID to run  USE `MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2` in the Impala query logs which then fails as that data base does not exist.

 

I see other users also generate the same statement.

 

Any idea what this is trying to do, or why it would be doing it?

 

If I was to create that database would it be used by anything?

 

Thanks

David Hanes

Moderator v-yuezhe-msft
Moderator

Re: USE `MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2` being sent to Impala via Direct Query

@DaveH,

Could you please post the full error message when using DirectQuery mode? And can you successfully connect to Impala database using Import mode?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DaveH Frequent Visitor
Frequent Visitor

Re: USE `MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2` being sent to Impala via Direct Query

Sorry for the late reply.

 

The error is only in Impala and it is : 

 

AuthorizationException: User 'sloongs' does not have privileges to access: MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2.*

 

The problem is that PowerBI is sending a USE statement to use a database called MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2 which does not exist in Impala. (the user also doesn't have access to a database of that name, but that is really besides the point).

 

This isn't a user requested database call.  It is being generated by PowerBI.

DaveH Frequent Visitor
Frequent Visitor

Re: USE `MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2` being sent to Impala via Direct Query

I didn't fully answer your question.

 

We can successfully query the Impala database in both Direct Query and Import modes.

 

The only issue is that PowerBI is sending the USE `MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2`  query to Impala when it shouldn't.

Moderator v-yuezhe-msft
Moderator

Re: USE `MicrosoftDataMashup9A8CF2764FB34AECA572E2789EB6B2A2` being sent to Impala via Direct Query

@DaveH,

You get the error only in your source, but everything works well in Power BI, right? If so, what is the result when you create the database mentioned in the error message and  give user access to the database?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)