Forum Discussion
Separating data modeling from power BI
I have a dashboard made out of one csv file . and as I have to do a lot of filtering and manipulation . I did a data model merely using the powerquery tool. So I have done a lot of merges in order t...
amitchandak
Super User
Super Userlatrous98 , You can consider Azure analysis services or Sql server analysis services for that.
Or do the transformation in on pbix and modeling in one pbix and report creation in another
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
I guess the more scalable option and more felexible are the first ones (and I guess sql serveur is the free one if I'm not mistaken if I want to make a local database)
I actually thought of etl solutions like talend but it seems that there is straight way to import the data
I don't know if you have already encountered that ?
thanks