Forum Discussion
New to BI. Writing SQL queries to parse data. I am obviously missing something.
Started using Power BI on the recommendation of a friend. It looks well made and powerful, so I hope to stick with it. I am pretty decent with SQL and can write some lengthy queries. My goal is t...
aspardo Another option here that hasn't been mentioned, and that I would recommend prior to doing any querying or mashups in Power BI would be to reduce your data set to only the information you need by creating a layer in your SQL database with Views. Then you can just connect to those views from Power BI and you don't have to worry about trying to trim things down after you've already imported or having to deal with writing the query from the editor.
This practice will also be very helpful when adding or modifying your dataset, as you have this additional layer.