Export a dataset from power bi service report

[unknown_anony]

Hello All,
I have report in power bi service and want to export a dataset table to build another report. The dataset is SAP business warehouse which i do not have access to, so i have to take table  from a report which is already build . Currently i am taking the dataset in direct query mode but for my requirement i need to write some dax query and calculated column which i am unable to do it now.  is there a way to export the dataset directly from the service report, or it is a long way to download the report export the table to excel?

Thank you in advance

[unknown_anony]

Thank you

[Ritaf1983]

You're welcome 🙂

[Ritaf1983 · Accepted solution]

Hi @unknown_anony 

Please refer to the linked tutorial.

https://www.youtube.com/watch?v=cT4JdClkLh8

I don't think that we have other alternatives.

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