We have a Power BI shared dataset sitting in a Premium Gen2 P1 capacity that users connect to through both Power BI Desktop and Excel. In the past, we've always instructed Excel users to connect to the shared dataset by going to the Data tab > Get Data > From Database > From Analysis Services.
Lately, Excel users have been reporting this error when issuing certain complex, and long running, queries: "Azure Analysis Server returned the following error: Bad Request".
Some users, apparently those with a Pro license, now have a new option: Get Data > From Power BI. Users using this approach do not encounter "Bad Request" errors when issuing the exact same queries from Excel.
I've noticed that the two methods, the older "From Analysis Services" and newer "From Power BI", generate different connection strings in the "Connection Properties" dialog.
Why does the "From Analysis Services" option generate an "inferior" connection string and how do we get users who don't have Pro licenses access to the "new" connection string if they can't use the "From Power BI" option? As the dataset is in a Premium capacity, I would think all users should be able to access it easily.