Best practice for data extracting and transformation

Hi Anonymous ,

There is no nessary to split this process into several documents in Power BI, you can do all of it in the Power BI Desktop and generate one document (or call it pbix file), It is also hard to split this process, a pbix file contain the connect information and the transform data depends on the connected data.

The common useage of Power BI is combine the Get Data step and Transform Data step, create report is optional, because when you publish the pbix file into Power BI Service, the transformed data will become a dataset, the report (even no visual in it) will become a report in Service, then you can create multi reports in Service depens on this dataset.

You can find a quick start about the Power BI Desktop here: https://docs.microsoft.com/en-us/power-bi/desktop-getting-started

Best regards,

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more