%pip install semantic-link-labs

import sempy_labs as labs
import sempy_labs.report as rep
from sempy_labs.report import ReportWrapper

# For checking reports
report_name = '' # Enter the report name
report_workspace = None # Enter the workspace in which the report exists
rpt = ReportWrapper(report=report_name, workspace=report_workspace)

rep.run_report_bpa(report=report_name, workspace=report_workspace)

import pandas as pd

rules = pd.DataFrame(
    [
        (
            "Error Prevention",
            "Semantic Model",
            "Error",
            "Fix report objects which reference invalid semantic model objects",
            lambda df: df["Valid Semantic Model Object"] == False,
            "This rule highlights visuals, report filters, page filters or visual filters which reference an invalid semantic model object (i.e Measure/Column/Hierarchy).",
            "",
        ),
        (
            "Performance",
            "Page",
            "Warning",
            "Reduce the number of visible visuals on the page",
            lambda df: df["Visible Visual Count"] > 15,
            'Reducing the number of visable visuals on a page will lead to faster report performance. This rule flags pages with over " + visVisuals + " visible visuals.',
        ),
        (
            "Performance",
            "Visual",
            "Warning",
            "Reduce the number of objects within visuals",
            lambda df: df["Visual Object Count"] > 5,
            "Reducing the number of objects (i.e. measures, columns) which are used in a visual will lead to faster report performance.",
        )
    ],
    columns=[
        "Category",
        "Scope",
        "Severity",
        "Rule Name",
        "Expression",
        "Description",
        "URL",
    ],
)

rep.run_report_bpa(report=report_name, workspace=report_workspace, rules=rules)

rpt.list_semantic_model_objects()

rpt.list_semantic_model_objects(extended=True)

dataset_name = '' # Enter the semantic model name
dataset_workspace = None # Enter the workspace name in which the semantic model exists (if set to None it will use the workspace in which the notebook is running)
labs.list_report_semantic_model_objects(dataset=dataset_name, workspace=dataset_workspace, extended=True)

rpt.list_custom_visuals()

rpt.list_pages()

rpt.list_visuals()

rpt.list_visual_objects()

rpt.list_report_filters()

rpt.list_page_filters()

rpt.list_visual_filters()

rpt.list_report_level_measures()

rpt.list_visual_interactions()

rpt.list_bookmarks()

rpt.set_theme(theme_file_path='/lakehouse/default/Files/CY23SU09.json')

rpt.set_theme(theme_file_path='https://raw.githubusercontent.com/PowerBiDevCamp/FabricUserApiDemo/main/FabricUserApiDemo/DefinitionTemplates/Shared/Reports/StaticResources/SharedResources/BaseThemes/CY23SU08.json')

rpt.set_page_visibility(page_name='Page 1', hidden=True)

rpt.set_active_page(page_name='Page 2')

rpt.disable_show_items_with_no_data()

rpt.remove_unnecessary_custom_visuals()

rpt.hide_tooltip_drillthrough_pages()