Open the Excel file in the above folder and create a basic table showing data for sales of houses in different areas
There are 5 types of building - in an ideal world, each viewer should only see their relevant category.
There are two options available: create 5 independent reports or use one report but filter it to show data only for the current user. The latter can be performed using roles:
Create a role for each house type, filtering using the PropertyType code. Look in the Property types sheet to find the codes.
Once you have made the roles, check that each is working using View Roles on the Home tab:
Publish the report in Power BI Service and check the roles.