Data source indentification

[Sagar1233]

How to identify data source details of the dashboard available in work environment, can we able to find the data source details from script whether the data coming from Excel, SQL, SAP or data lake.

[micheledenardi]

Usually, when i have multiple data sources in the same final table i create a field [Data Source] in order to understand where the data are coming from.

Something like this:

FinalTable:
Load *,
  'ActualData.qvd' as [Data Source]
From ActualData.qvd(qvd);

Concatenate(FinalTable)
Load *
  'BudgetData.qvd' as [Data Source]
From BudgetData.qvd(qvd);

Concatenate(FinalTable)
Load *
  'ExcelData.xlsx' as [Data Source]
From ExcelData.xlsx (.....);