I just resolved my "error on data source access, contact gateway admimistrator" issue. Looking through the gateway logs revealed that the gateway was looking for MSOLAP.5. This is MSOLAP 11.0, which is SSAS 2012. So I downloaded & installed the SSAS2012 64-bit msolap, and now the report runs fine in the service.
The tabular model the power bi report is connecting to is ssas 2017.
1) Why is an old version of msolap being used here instead of whatever the most recent version is?
2) How can I direct that the newest msolap version be used?
3) Will this be an issue for my users? Will I need to direct every report consumer to download & install ssas2012 msolap? That seems like a terrible user experience.
Thanks for any tips!
The data source for my power bi report is an on-prem ssas 2017 tabular model in live/direct query mode. The report was fine in power bi desktop, and then didn't work when published to the service - which led me to the discovery that the gateway logs had the ssas2012 driver issue.
Coolness. So what's the impact for other consumers of the power bi report? Will they experience the same issue, needing to have a correct version of msolap.dll registered?
Or is this only a prereq on the box hosting the gateway? And if this is the case, why is the prereq an *old* version of msolap.dll and not the newest one (which was already installed/registered)?