Forum Discussion
DPCCGF
3 years agoHelper IV
Understanding of Report Server Datasets
I rarely deal with Report Server but now have someone that uses it. It is my understanding that you cannot "Get Data" from a dataset on the Report Server. Is that correct? If yes, I would assume t...
KBO
3 years agoMemorable Member
Hi DPCCGF ,
Normally If you want to create Dataset for several Reports you can create a SSAS (it is like a Dataset in Power BI Cloud). And to this Dataset you can use Live Connection. And of course you can use a Direct Query in Report Server as well to a SQL DB for example 🙂 But be aware of limitations in the Data Sources and that you need some drivers for some Sources 😉 like ODBC.
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!