Is there something wrong with 'Analyze the results of this query'?

Get Help
1

Hi there!
there's a question trouble me.
when my team member use 'Analyze the results of this query',they can't download the result.but I can(I'm administrator).please help me!!!It shows like this:

question
question1867×468 21.4 KB

Running metabase 0.31.0 here.

2

Hi @mushroom
You might want to upgrade to 0.31.2, since there were permission fixes.
Maybe the users don’t have data access? Check in Settings > Admin > Permissions.

3

I’ve checkd,they have data access :joy:,thank u very much!

4

I’ve upgraded to 0.31.2 ，but the issue still exist

5

@mushroom
Are you also having problems with permission on Collections, where Filters in Dashboards doesn’t work for your users?
Then it could be related to this bug: https://github.com/metabase/metabase/issues/9270

6

no，I’ve given them unrestricted access to both collections and data.As I I known,permission of dashboards is determined by the permission of collections and data,is that right?

7

Are you using Foreign Keys to tables, where the users don’t have permissions?
https://github.com/metabase/metabase/issues/7928
Check your browser console for errors - or the Metabase log.

8

I guess my issue has nothing to do with Foreign Keys tables （only one table was queried）.I’m checking the log

9

I’m sure it’s a bug.:sweat_smile:It sometimes work sometimes not!!!oh,my god! I just download the result successful,all steps are the same

10

It doesn’t work again，the error shows API endpoint does not exist

11

@mushroom

You have to post the error - you can remove sensitive information like domain name.

And can you post an example, when it works - an when it doesn’t work.

12

The question is a native query，and the steps are as follow：

1
11835×798 78.2 KB

13

2
21857×763 106 KB

14

when it works，they can downlaod the result.When it doesn’t,the error like this:

3
31245×872 45.2 KB

15

And I've checked the log,the log shows the error is they don't have query permission,but I've given them unrestricted access to both collections and data. The log is as follow:

4
4918×756 17 KB

16

5
51040×571 11.8 KB

new users can only put one image in a post,sorry for multiple responses @
flamber

17

@mushroom

I have never seen something like that before.

Does the problem only happen on specific questions?

Or is it any question, but sometimes you can download other times you get the error “API endpoint does not exist” ?

18

It happens on any native query questions

19

@mushroom

Okay, so now I’ve replicated it :clap: :clap: :clap:
The only solution I have right now is to grant access to “SQL Queries” for that group (or All Users) :frowning:

But I’ve already created the bug - go and vote by clicking the :+1:

20

Thank u so much!