Forum Discussion
Advocate IIIBuild permission on semantic model does not allow user to use semantic model in Power BI desktop
Hi KimTutein
If the user has the correct permissions but still cannot see the dataset in Power BI Desktop or Data Hub, try the following steps:
Ask the user to clear their Power BI Desktop cache:
- Go to File > Options and Settings > Options > Diagnostics > Clear Cache.
Ensure the dataset isn't hidden from the Data Hub:
- In the Power BI Service, go to the dataset settings and check that Featured in Apps or Certify/Promote options are enabled for better visibility.
Confirm that your Power BI admin tenant settings allow external connections like Analyze in Excel and viewing datasets.
Create a test user with identical permissions to replicate the issue. If it persists, there might be a bug.
Revoke and reapply Viewer and Build permissions to refresh the user's access.
- If none of these work, it could be a backend issue—reach out to Microsoft Support for further assistance.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Advocate IIIHi Poojara_D12
Thank you for your reply it is much appreciated.
I have triple checked that the User has view role on the workspace and Build permission (I am not trying directly on the user so not even via. a group). He also have Read and ViewOutput. He can however not see data set in “Get Data” => “Power Bi Dataset” in either Power BI Desktop or Excel and not in the Data Bub either. If I connect the semantic link in a Excel workbook and send it to him he is able to use the Excel spreadsheet and pivot the semantic model.
Anything else you can come up with I should try out?
- Poojara_D12
Super User
Hi KimTutein
If the user has the correct permissions but still cannot see the dataset in Power BI Desktop or Data Hub, try the following steps:
Ask the user to clear their Power BI Desktop cache:
- Go to File > Options and Settings > Options > Diagnostics > Clear Cache.
Ensure the dataset isn't hidden from the Data Hub:
- In the Power BI Service, go to the dataset settings and check that Featured in Apps or Certify/Promote options are enabled for better visibility.
Confirm that your Power BI admin tenant settings allow external connections like Analyze in Excel and viewing datasets.
Create a test user with identical permissions to replicate the issue. If it persists, there might be a bug.
Revoke and reapply Viewer and Build permissions to refresh the user's access.
- If none of these work, it could be a backend issue—reach out to Microsoft Support for further assistance.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS- KimTutein