Forum Discussion

StephenF's avatar
StephenF
Responsive Resident
4 years ago
Solved

Filtering dataflow

Anyway to request only certain rows from a dataflow like you can with a direct sql datasource?   I only want to get the most recent days data from a rather large dataflow table.
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi StephenF,

I check the document of the rest API but did not find the corresponding API to achieve your requirement.

Dataflows - REST API (Power BI Power BI REST APIs) | Microsoft Docs

If you are working with the power bi dataset, you can enable the XMLA endpoint to accurately manage these.

Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs

For this scenario, maybe you can try to use query parameter with your dataflow:

parameters-dataflows-power-bi-service-power-query-powerbi (p3adaptive.com)

Regards,

Xiaoxin Sheng