Forum Discussion
Rohini
Helper I
Helper IXMLA Endpoint rows restriction
Hi, I am trying to connect the dataset of Power BI dashboard A to extract over 1 million rows, however my dashboard B is able to produce only around 135k rows. Is there an issue with the settings tha...
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