Which data connectivity i will connect?

Hi team,

Greeting and Good Wishes!

please understand my problem give me best solution depending your replay i am following creating reports

1.I Have 5 columns coming from 1 table and 3 measure and 1 column created in Power BI
2.my datasource is Azure sql datbase
3.my data loaded in databse Yesterday(today-1) data for every day
4.My client using Power Bi pro lience

my Question:
1.I am connectivity mode is Import(Refresh mode) becouse my data report showing Yesterday(today-1) data(full day i am showing yesterday data only)
please suggest me if i am thing wrong(here not required Direct connectivity mode)

2. now i have 6 reports created using one dataset(one table)
but 6 dataset created in Power BI service( I hope data size increase) here schedule refresh each data source need create?
if i will connect "Power BI datasets" its good solve my problem.
or any other method to solved
--(my client required around 100 reports using 5 to 7 table)

3.its fit my problem as Dataflows using Power Bi pro lience

please suggest me which method i need use.

Thanks

Shanvitha