1 dataset several report

[Lalaina]

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

[KBO]

Hi @Lalaina ,

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!

[Lalaina]

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

[KBO · Accepted solution]

Hi @Lalaina ,

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!