Extracting data from data warehouse but need further modeling and cleansing

Hi ANNING 

Your questions are very right to the point. 

Answers:

• Scenario A : Power Query in Power BI is an ETL tool that can help you do all your cleansing and transformations with just simple clicks. It is very powerfull tool.
• Scenario B : Yes you can Model your data into Power BI same as in SQL Server. Using DAX can help you acheive your goals as well.
• Scenario C :
  • Q1 : Know that you can apply your SQL statement right into Power Query. When you Get Data

     

  • Q2 : Testing is your best way to verify. But I can assure that it will feed your semantic model as you wish
  • Q3 : As said before Power Query is very powerful tool for an ETL and Modeling is very easy In Power BI. However, Even though Importing records into Power BI is the best connection mode but there are situation where some work needed to be done at the Warehouse level. Like using DQ mode if the the fact table is huge or using incremental refresh for performance reasons... It all depends on the BI analysis and situation.

Sorry but Not true. Power BI is no longer just a visualisation tool espacially with Fabric on the horizon. Power Query is an ETL, Modeling and DAX and the semantic model you build can be a Data warehouse itself. Exemple : Building a Semantic model (Dataset), Publish it to the service and give access to developpers to reuse it from Power BI desktop via AAS to also build other semantic models on top of it...