Need suggestion on designing the power bi solution for multiple sources

[Anonymous]

Hi all, I have got requirement to create reports which gets data from 4-5 different sources. So basically, I need to get similar type of data for different countries which are stored in different Azure DB's and then aggregate the data and build the reports so RLS will be applied on countries.

Suppose I have incident tablein all DB's(with same structure) and combined them in power query(append) and create master table to develop the reports.

So for this use case , what is best solution to start the development so that power bi data model will be robust/doesn't impact the performance while adding data from more sources in future.

I was thinking to use Dataflows for ETL ,Dataset for data modeling and Reports for visualization.

Please advise or suggest

Looking forward to hear from all of you !
Thanks in advance

[lbendlin]

Please provide more details.  How many rows in these tables? How many columns? How often are they refreshed?

You may not need to use dataflows in such a scenario.

[Anonymous]

@lbendlin , Thanks a lot of looking into this.

Please find the below information for one of the fact table in 1 DB
Rows - nearly 2 lacs of 1 year
Columns - 425 (we might require 50-80 columns for reporting)
Refresh time - it should be daily refresh for reporting or may be every hr. 

Reporting DB gets data from CRM dynamics so whenever any changes in CRM , DB gets updated in real time .
Data retention period will be 3 years for reporting .
Should we go for ADF instead of Power BI Dataflows ?