I have a query that I've been working on this week and I was able to use it until about 2PM yesterday. The query is connecting to our SSAS data cube. I have tried going back to a previous version of the file from earlier this week to no avail. I can tell that the rows are not coming through because I have no option to cancel the data load nor can I see the amount of rows loaded. This should not be a network issue, as I can connect to the server and view the data from a different BI application that we use (connecting to the same cube).
I also tried clearing my credentials and entering them again, but it's taking a very long time to authenticate. I've tried recreating the query by copy and pasting the M Code into the advanced editor and this does not work either. Does anyone have any recommendations or has experienced something similar?
>>I have tried going back to a previous version of the file from earlier this week to no avail.
I'm not so clear about this, can you please share more information about this? (e.g. connection mode, any advanced query operation s in query editor)
In addition, I test to get data from SSAS and both import and live connection mode works well.