Skip to main content

    Power BI

    New

    Create Power BI Report in Report Server using shared dataset created with Report Builder

    Vote (44) Share
    's profile image

    on 18 Aug 2018 00:36:19

    We should be able to create Power BI Reports inside Report Server using shared dataset created with Report Builder since there is no option to share datasets throught PBI Reports.

    Comments (4)
    's profile image Profile Picture

    82006394 2614-4484-8601-ad800ebd8cc0 on 06 Jul 2020 00:15:01

    RE: Create Power BI Report in Report Server using shared dataset created with Report Builder

    We have over a hundred dashboards that have a couple of the same datasets for our geographies. it would be really nice to not have to replicate them in each dashboard on our power bi server

    's profile image Profile Picture

    6c70ac3c d59d-47d1-a2d9-20ec20e82ef9 on 06 Jul 2020 00:05:19

    RE: Create Power BI Report in Report Server using shared dataset created with Report Builder

    WE need this option as soon as possible since more and more reports are being used and the business is looking for options to send it to the end user over email.

    's profile image Profile Picture

    ad7583d9 4614-4a21-84fa-c57d868952ca on 06 Jul 2020 00:04:03

    RE: Create Power BI Report in Report Server using shared dataset created with Report Builder

    Would be great if with power bi desktop report server we could be able connect to datasets we have already created in the report server also use the dataflow option. In that way we could have one more security layer with the final user and optimize the use of data.

    's profile image Profile Picture

    de1e6f64 56cd-4f90-9a12-580420b3df80 on 05 Jul 2020 23:42:31

    RE: Create Power BI Report in Report Server using shared dataset created with Report Builder

    We're currently doing this using the PBI REST API and an OData source in the Power BI Report. Check out the REST API Documentation

    https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/DataSets/GetDataSets

    Our primary data sources rely on custom data delivery providers created and published using SSDT so the REST API and OData is the primary method we're consuming that data within Power BI Reports. We are using the on-premise Power BI Report Server