Analyze in Excel: How to force Credentials Window / Password Prompt to pop up
I need assistance to force Excel to ask for User Credentials / Password Prompt when accessing Power BI data. I am using Analyze in Excel that connect to a Power BI datamodel that is located in the service. I am logged into my Excel Desktop app and can see the Power BI Datamodel/Dataset. However, once selected, as it tries to load there is an error that says: "Cannot create the PivotTable. An error has occurred when creating the PivotTable. Please make sure that you have permissions to the data, that the model is valid and the credentials are correct." There is a similiar issue when using Excel for Web. The user profile has full permissions over the datamodel/dataset. The first image is what I need to pop up. The second image is the error I'm getting (without being prompted to confirm credentials. user already signed in)
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.
