Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago

Push with expression

RuiRomanoMS Is there any way for me to incorporate an expression in a push dataset while using the rest api ?     I tried this which did not work   { "name": "SalesMarketing", "...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, smpa01 

The Power BI REST API doesn't support the use of expressions when creating a push dataset. The data pushed to the dataset should have been processed and ready to be visualized.

If you need to perform transformations or use expressions on your data, you might want to consider doing so before pushing your data to Power BI. This can be done in your own application or with Power Query in Power BI Desktop. Once the data has been transformed, you can use the REST API to push the resulting dataset to Power BI.

 

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

smpa01's avatar
smpa01
Community Champion
2 years ago

Anonymous  thanks for looking into it. I have a push datset in production and they were created utilizing PostDataset and PostRow.

 

However, PostDatset has ASMashupExpression definition and I am simply trying to understand what is the purpose of that?