Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

1 dataset several report

Hi everyone, 

 

1/ I use API/Excel file to retreive data from PBI desktop for 1 report

2/ Now I would like to use the same dataset within several report without using the same code as in 1/ to optimize the number of API call or to make sure that my data are consistent acroos all report

 

Is there a way to import dataset in the server directly and to connect the dataset to multiple report 

 

Thanks 

L

dataset
Server
  • KBO's avatar
    KBO
    6 years ago

    Hi Anonymous ,

    If your question is answered please close this issue to help others :).

     

    Best,

    Kathrin

     

     

     

     

    If this post has helped you, please give it a thumbs up!
    Did I answer your question? Mark my post as a solution!

3 Replies

  • KBO's avatar
    KBO
    Memorable Member
    6 years ago

    Hi Anonymous ,

    you cant use datasets on the report server but you can create a SSAS cube and use this as datasource for multiple reports :).

     

     

    Best,

    Kathrin

     

     

     

     

    If this post has helped you, please give it a thumbs up!
    Did I answer your question? Mark my post as a solution!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks I will continue to call the API directly as it costs to maintains an additional db 

      • KBO's avatar
        KBO
        Memorable Member
        6 years ago

        Hi Anonymous ,

        If your question is answered please close this issue to help others :).

         

        Best,

        Kathrin

         

         

         

         

        If this post has helped you, please give it a thumbs up!
        Did I answer your question? Mark my post as a solution!