Forum Discussion

KimTutein's avatar
KimTutein
Icon for Advocate III rankAdvocate III
1 year ago
Solved

Build permission on semantic model does not allow user to use semantic model in Power BI desktop

I have a problem with granting build access on my semantic model which I find rather strange. I have a workspace with a semantic model which uses direct lake on a lakehouse. If I grant user viewer ri...
Need Help
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    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:

    1. Ask the user to clear their Power BI Desktop cache:

      • Go to File > Options and Settings > Options > Diagnostics > Clear Cache.

    2. 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.

    3. Confirm that your Power BI admin tenant settings allow external connections like Analyze in Excel and viewing datasets.

    4. Create a test user with identical permissions to replicate the issue. If it persists, there might be a bug.

    5. 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's avatar
KimTutein
Icon for Advocate III rankAdvocate III
1 year ago

Hi 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's avatar
Poojara_D12
Icon for Super User rankSuper User
1 year ago

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:

  1. Ask the user to clear their Power BI Desktop cache:

    • Go to File > Options and Settings > Options > Diagnostics > Clear Cache.

  2. 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.

  3. Confirm that your Power BI admin tenant settings allow external connections like Analyze in Excel and viewing datasets.

  4. Create a test user with identical permissions to replicate the issue. If it persists, there might be a bug.

  5. 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's avatar
    KimTutein
    Icon for Advocate III rankAdvocate III
    1 year ago

    Thansk Poojara_D12 

     

    I will try it out - thank you for guidance.