Self-Query Tool
Not sure if this is the right place to ask this so forgive me if its not. I'm looking to find a tool that is easy for business analysts to use for self-querying and extracting/exporting data from Power BI datasets. DAX Studio is great and, for the most part, very easy to use. However, when it comes to logical OR conditions and nested filtering (nested ORs, ANDs) there doesn't seem to be any easy way to do this. Instead it requires manual manipulation of the DAX code. Analyze in Excel is also great but it too (and Pivot Tables in general) doesn't seem to have a way to do complex filtering nor long list filtering. It would be great if the business analysts would just learn DAX but, in my organization at least, there is not a willingness to expect that from the analysts nor the will/resources to train them. Same goes for SQL. Plus, mastery of DAX can be a very long, difficult road. Looking for a drag and drop type experience. Thanks in advance for any suggestions as to tools I can take a look at.