Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Power BI Server is this a preview\beta product?

Hi   Is Power BI Report Server officialy released product or is this preview\beta only. Is there any one on this forum that is using this in their production environment?   Jaco
Power BI Report Server
vickyd's avatar
vickyd
Icon for Helper V rankHelper V
9 years ago

"You can filter data in your Queries in Power BI Desktop. I imagine there might be more to your end-to-end scenario I might be missing?"

 

Does it filter from source though i.e. does it pull only the filtered data from source or pulls everything and then filters? 

riccardomuti's avatar
riccardomuti
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Yes, Power BI/Power Query tries to push filters and some other data transformations down into the query it generates (e.g., into the SQL WHERE clause, in the case of a relational database) as much as possible, and filters post-query as a fallback. You can use SQL Profiler to see what it was able to push down into the SQL query. (Alternatively, you can specify your own SQL query and it'll just run that.)