Need help in assessing power BI on few parameter..

Hi manishbcg,

1- Data sources and Modelling

Regarding supported data sources in Power BI, see:

Data sources in Power BI Desktop

Data sources for the Power BI service

Regarding data modeling, please go through this tutorial: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-1-intro-modeling-data/

Also below articles should be helpful:

Common query tasks in Power BI Desktop

Shape and combine data in Power BI Desktop

2- Data Integration with self-service

Power BI provide a number of services you use to run your business, such as Salesforce, Microsoft Dynamics, and Google Analytics. See: Connect to services with content packs for Power BI.

3- Data Format (wide/long/any)

In Power BI desktop, under Data Modeling tab, you can set data format:

4- Data Refresh (first time rendering & refreshing)

See: Data refresh in Power BI

Best Regards,
Qiuyun Yu