SQL Validation Power BI Dashboard

I have a SQL Server view that already aggregates every validation script we run on raw_valid and model_valid. What I now need is the front-end: an interactive Power BI dashboard built in a tabbed interface that surfaces those scripts, lets users explore them, and provides both basic text search and advanced filtering.

Connection & data model
• Connect directly to the existing view (read-only).
• Expose the script name, object type, target table, last run date, status, and the full script body or a hyperlink to it.
• Optimise the model so the dashboard opens quickly even when the view grows.

Visual & navigation requirements
• Two main tabs—one for raw_valid scripts, one for model_valid—each mirroring the same layout for consistency.
• Search bar on each tab for quick keyword lookup plus slicers/filters (status, target table, date range, author, etc.) for advanced narrowing.
• Click-through action: selecting any row or card should reveal the full SQL text or redirect to its stored location.

Publishing & hand-off
Please deliver the PBIX file, separate theme file (if used), and a short README explaining data source parameters so I can swap in a different server if needed. If possible, include a brief note on incremental refresh or other performance tweaks you applied.

Acceptance criteria
1. Dashboard loads without credential prompts once my gateway is configured.
2. Tabs, search, and filters all return results in under three seconds on my test set.
3. Click-through reliably displays or links to the exact script selected.

If you have questions about the view structure, let me know and I’ll share a sample dataset.