Dashboard with question, answer and link the source

Hi swathrddy ,

You can follow the steps below to get it:

1. Prepare the data with columns for question, sub‑question (if any), answer, department, source, link, and additional columns

2. Load the data from the source files into Power BI after well structured data in the data source side

Import Excel workbooks into Power BI Desktop - Power BI | Microsoft Learn

3. Use Power Query Editor for shaping and standardizing the data

Query overview in Power BI Desktop - Power BI | Microsoft Learn

Query Editor in Power BI for Data Transformation - GeeksforGeeks

4. Data modeling(create relationships)

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

5. Create a matrix or table visual

Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Learn

6. Publish the report to Service

Publish from Power BI Desktop - Power BI | Microsoft Learn

7. Create dashboard

Create a Power BI dashboard from a report - Power BI | Microsoft Learn

Best Regards