ConfigureWorkspaceApp.md

Demostration: How to Configure Workspace App

Costa Rica

brown9804

Last updated: 2025-04-21

---

How to create a Power Bi Workspace App from the beginning and share it with external users. The same steps apply to security groups; simply replicate the process for a security group and add members to it.

1. Create your Fabric Capacity

   

2. Go to Fabric, and assign the capacity created to the workspace desired.

   
   

   
   

   Select the large semantic model only if your model exceeds 10 GB. If not, use the small model. The large setup is for models up to 10 GB.

   

3. Create a lakehouse to store your data:

   

4. Get your data, in this case a CSV file will be used

   

5. After uploading the information, create the tables or upload the information to your existing tables:

   

6. Create a semantic model based on your tables:

   

7. Now you are able to create a report based on the semantic model created, you can ask copilot to create a draft report with the Auto-create report option.

Note

Make sure to activate the setting under Admin Portal -> Tenant Settings -> Copilot/Data -> Enabled. Click here for more details

• You will see something like this:

  

• You can leverage copilot to modify your report:

  

• Once you are ready, save your report:

  

• At this point you will have your lakehouse, with your SQL analytics endpoint, the semantic model and the report.

  

8. A paginated report, can also be created:

   

9. Create an App, and assign the required audience:

   

Important

If you encounter these errors, it's necessary to grant the appropriate (semantic model, sql analytics endpoint, and the app permissions for access.

• Let's say you want only viewer permissions:

  1. Need to give access to the lakehouse/sql analytics endpoint:

     

     Read All SQL Endpoint Data permission allows users to access and read data from SQL endpoints within the Fabric environment. This permission is typically required for users who need to:
     

     • Query Data: Execute SQL queries against the data stored in the Fabric environment.
       
     • Access Reports: View and interact with reports and dashboards that rely on SQL data sources.
       
     • Data Analysis: Perform data analysis and generate insights using SQL-based data.

     

  2. Make sure the person already have access to the semantic model:

     

• Granting Read, ReadData access to the semantic model, sql analytics endpoint
  
• Grating App audience will enable the assigned identity to view it.

Refresh Date: 2025-10-15