Hi @Rohini ，
1. What are the data sources for the dataset of Dashboard B? The following datasets aren't accessible by using the XMLA endpoint.
- Datasets based on a live connection to an Azure Analysis Services or SQL Server Analysis Services model.
- Datasets based on a live connection to a Power BI dataset in another workspace. To learn more, see Intro to datasets across workspaces.
- Datasets with Push data by using the REST API.
- Datasets in My Workspace.
- Excel workbook datasets.
2. Try the steps in this blog.
How to Export Data from Power BI using XMLA Endpoints
3. Related Questions:
Solved: Extracting data from dataset using XMLA or REST AP...
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
