Error: Direct query to dataset in Premium Workspace

[TWolsten]

Hi there,

I was wondering if there is a limitation with Premium Workspaces whereby you cannot use the recently released feature of direct querying datasets within premium workspace.

I have successfully connected multiple datasets which sit in non-premium workspaces but when I try and connect to a dataset within a Premium workspace I get the below error, and it is not a permission issue as I am the admin of the workspace:

Any help resolving this would be greatly appreciated otherwise I guess I will have to have a non-premium workspace for reports and premium for dataflows.

Thanks in advance! 

[v-angzheng-msft]

Hi, @TWolsten 

I don’t think the Premium workspace has some limitations that the non-Premium workspace does not.

According to the error shown in the picture above, you may not enter the credential information correctly or you do not have sufficient permissions.

The permission here refers to that you can access the model but not the workspace. You are the administrator of this workspace, which is not helpful. 

Please check whether the server name and database name in the connected model are entered correctly. If this does not work, please contact the model manager to grant you access to the model.

If none of these work, please report the issue as suggested in the picture above.

https://community.powerbi.com/t5/Issues/idb-p/Issues

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