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
