Power BI reports in excel

[ramkula]

Hi All, 

We have published around 5 different reports(direct mode) into PBI services. These reports have tabular visuals . Now we would like to get the data from these 5 reports into 1 excel file in different tabs and should be able to refresh data .

I see that there is an option in excel -- Get data--Power BI , but this only gets data in pivot table. 

Is there an option to get the tabular data from the report into exc

[v-janeyg-msft]

Hi, @ramkula 

Sorry, AFAIK, There is no funtions that meets the two needs at the same time. 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If you can change your needs and still need help, please feel free to ask me.

Best Regards,

Community Support Team _ Janey