Forum Discussion
Unable to render Paginated report
I have created Dataflow using On-permises data gateway to connect to SQL sever tables. Then I have created datamart that uses that dataflow as data source. The Dataflow and datamart resides in Premiu...
lbendlin
Super User
Super UserWhat's the purpose of the dataflow and datamart? What happens when you point your paginated report directly at the SQL Server source?
This report is one of the 200+ reports that are currently in Webi and I am trying to move them to Power BI. Since many reports will be using same tables as data source, I am trying to reduce the connections to the table by creating dataflow. Also by creating dataflow/datamart, I can transform the data in a way that someone without deep knowledge of table relations can use them to create reports.
- lbendlin
Fair enough. You may want to start reading up on Fabric capabilities.