Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 then that each report needs to have the data actually in the PBIX file before you save it to the Report Server. If yes, is that not rather inefficient? Or does Direct Query work so well on Report Server do people do just that? Just curious how you all operate out there. Thanks...........
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
19 | |
16 | |
3 | |
2 | |
2 |