danielfgodoi's avatar
danielfgodoi
Advocate I
8 years ago
Status:
Needs Votes

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

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.
power bi

9 Comments

  • joshua_prickett's avatar
    joshua_prickett
    New Member
    6 years ago
    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
  • alexisg0886's avatar
    alexisg0886
    New Member
    6 years ago
    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.
  • krishna_venkata's avatar
    krishna_venkata
    New Member
    6 years ago
    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.
  • daniel_rowe's avatar
    daniel_rowe
    New Member
    6 years ago
    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
  • a_losi's avatar
    a_losi
    New Member
    5 years ago
    We want to access shared dataset as odata feed with power bi report server to consume some data with scripts.
  • Ahmed_S_Yehia's avatar
    Ahmed_S_Yehia
    New Member
    4 years ago

    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

  • fbcideas_migusr's avatar
    fbcideas_migusr
    New Member
    3 years ago

    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.

  • Cody_Wise's avatar
    Cody_Wise
    New Member
    2 years ago

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

Recent ideas