Analyze In Excel has been unreliable yesterday and today. In workbooks regularly used each week without issue, many cube values now produce #N/A's, yet return values when changing seemingly unrelated...
mikegunns
Helper I
Helper II have also uploaded the same dataset to a different workspace and tried changing the connection string for one of the problem workbooks to the new .odc, to no avail. Still getting the #N/As. Again, if connected to the local .pbix, all the cube values populate correctly.