Forum Discussion
data load best practice for relational source but complex transformations
All of my data sources are SQL Server, making them a candidate for query folding. However, my transformations are complex, which prevents query folding. I have found that writing the transformation...
I would say yes and you also want to be building views in SQL then just pulling the view into PowerBI. Take a look at this article on the topic.
https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/
jdbuchanan71
Super User
Super UserI would say yes and you also want to be building views in SQL then just pulling the view into PowerBI. Take a look at this article on the topic.
https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/