Mixed Mode Dataset issues - Cannot load the data for this visual

[NandyFPS]

Hi all,

Hopefully someone has some experience working with mixed mode datasets.

I have a mixed mode dataset deployed to the service, a report over this works fine for me, however everyone else recieves errors on all visuals 'Cannot load the data for this visual'.

Workspace is on premium capacity.

Dataset A is Import mode consuming data via a on prem gateway (Test user is assigned read & build permissions)

Dataset B is Direct query to Dataset A in the service with some additional data from on prem gateway (Test user is assigned read & build permissions) connection to Dataset A is via a shared cloud connection with Azure SSO enabled.

Test user access's via App and has read access.

Tried many things and cant crack the issue, any help greatly appreciated!

[ajohnso2 · Accepted solution]

Erggh.. Resolved 

Allow XMLA endpoints and Analyze in Excel with on-premises datasetsEnabled for the entire organization

This Tenant setting was not enabled for all users. Now working!

[aj1973]

Hi @NandyFPS 

You need to add permission to Users/Group directly to different Datasets in play

[NandyFPS]

Thanks Amine, users are already setup with build permissions on both datasets

[aj1973]

Giving access to Dataset B through access to dataset A doesn't mean you are giving access to B as well.

I hope it is not your case in here!!!

[NandyFPS]

The user has been granted build permissions individually on dataset A and on dataset B am I missing something?