Forum Discussion
ryan_b_fiting
Post Patron
Post PatronPower BI - Architecture Best Practice
Hello Community - We are converting our Power BI instance from referencing mostly flat files on sharepoint to a true SQL Server Data Warehouse and I am looking for some best practices on the Pow...
Hi ryan_b_fiting ,
Yes, using dataflows is a good idea if you are making transformations in Power Query.
Import mode is an alternative to Direct Query, but using it depends on the amount of data you have.
Here is some additional information:
https://radacad.com/power-bi-development-best-practices
https://radacad.com/directquery-live-connection-or-import-data-tough-decision
djurecic
Super User
Super UserHi ryan_b_fiting ,
Yes, using dataflows is a good idea if you are making transformations in Power Query.
Import mode is an alternative to Direct Query, but using it depends on the amount of data you have.
Here is some additional information:
https://radacad.com/power-bi-development-best-practices
https://radacad.com/directquery-live-connection-or-import-data-tough-decision