Power BI Source Data Best Practise

[Krishnan_V47]

Hi All,

I am using excel files as data sources. I have loaded the excel files, done transformation of data in power query and loaded it into Power BI tables and created reports.

Now in future if my organization changes to other tools (eg Tableau or Microstrategy), I will again have to do the transformations and load the data.

May I know if there is a better way to do transformations and store these transformations and data outside of Power BI so that in future I can use this data in any reporting tool. Please let me know if there is any blogs/articles related to this subject.

[Krishnan_V47]

Thank you @Tahreem24 . May I also know if there is any blogs/articles/youtube videos related to this.

[Tahreem24 · Accepted solution]

@Krishnan_V47 ,

https://www.guru99.com/etl-extract-load-process.html

https://www.google.com/search?q=how+to+create+etl+layer&rlz=1C1GCEA_enIN855IN855&source=lnms&tbm=vid...

[Tahreem24]

@Krishnan_V47 My suggestion is to create an ETL layer by using any database tools like SQL, Oracle, Postgre etc. And do all the transformation and cleaning of data in database only. And this database you can easily access in any other BI tools.