get data from report using rest api

[saranrajk]

Hi,

I'm trying to get data from the report using the rest api and also I'm looking for getting data based on measuure and dimension, and how get data based on given dax expression tec.

[v-piga-msft]

Hi @saranrajk ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @saranrajk ,

I'm afraid that we cannot get data from rest api based on dax expression or measure in Power BI.

We could get data from rest api with Parameter. Please refer to the two similar threads.

https://community.powerbi.com/t5/Desktop/Dynamic-connection-to-Web-URL/m-p/346607#M155589

https://community.powerbi.com/t5/Integrations-with-Files-and/Parameters-for-JSON-API-data-Maintain-Q...

In addition, if you want to create chatbots in power bi, you could have a good look at this blog.

Best  Regards,

Cherry

[saranrajk]

Hi,

I'm trying to build a chatbot for that, the user can ask some question qlik sales by branch, sales by country etc. So, I have to get date based on fields is there any way to do it. And I'm also looking to get data from resport or data set etc..is there anty way to do it.