Forum Discussion

Rohini's avatar
Rohini
Helper I
4 years ago

XMLA 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 that is limiting the rows?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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