none
Power BI Feature to create Customized Excel report out of PowerBI dataset RRS feed

  • Question

  • Hi,

    I have been using Power BI for quite a while until recently a client of mine is asking for a requirement.

    They want the PL statement, Balance sheet reports in their official standard format in Excel file on a single click of a button from within the Power BI Dashboard.

    I see that the there is no option in Power BI to create custom Balance sheet like report from the available datasets which can be exported to excel.

    So I tried to create Excel file with R in PowerBI desktop . But found that XLSX package is not supported in Power user cloud, hence that idea is dropped.

    Next Obvious trial would be to call the PowerBI Restful API from external server and call that URL from within the button dashboard Image.
    Ref: https://powerbi.docs.apiary.io/#reference/datasets/datasets-collection/list-all-datasets

    But here I see that not all resources are being exposed by the API (https://msdn.microsoft.com/en-us/library/mt203551.aspx)

    So:

    1) Is there any API to fetch subset of data from Specified Dataset?

    2) Can XLSX package be added as supported for R in cloud? and in that case how to force that R script on click event of  a button/Image?

    3) Is the export dataset to Excel in customized format at all possible in any way?

    Please suggest.

    Thanks and regards in advance..


    Friday, December 1, 2017 11:43 AM

All replies

  • It seems to be an unconventional requirement though, but this is a valid feature to also support custom reporting template to be exported to multiple file formats.

    Can anyone from the Power BI team take a look at this requirement.

    Monday, December 4, 2017 6:51 AM