Skip to main content

    Power BI

    Needs Votes

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

    Vote (79) 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 (8)
    's profile image Profile Picture

    Cody Wise on 13 Dec 2023 16:57:06

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

    This is a really large hole in functionality of hosting a PowerBI Report server on prem. Please add this feature.

    's profile image Profile Picture

    Shaun Luper on 02 May 2023 00:22:54

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

    Not only does the Odata solution require the data to be reimported, not having acccess to the full published data model means any measures in the published model cannot be accessed either. Sure we be nice to be able to publish a solid data model and let users connect to it and report against it to their liking.

    's profile image Profile Picture

    Ahmed Yehia on 21 Mar 2022 11:01:47

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

    ODATA requires Data Import and this means the data will be imported again to the report own Dataset and this means duplication of data again.this feature is highly required

    's profile image Profile Picture

    Alessandro Losi on 08 Jun 2021 10:14:58

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

    We want to access shared dataset as odata feed with power bi report server to consume some data with scripts.

    's profile image Profile Picture

    Dan 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

    Krishna Venkataraman 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

    Alexis García 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

    Josh 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