Forum Discussion
Gateway - Unable to Configure SQL Analysis VIA HTTP Data Pump
When publishing a Report from PowerBI Desktop with a WORKING datasource direct (aka IMPORT as Live is greyed out) connection to HTTPS://Server/msmdpump.DLL to PowerBI online, the Gateway Datasource C...
Be careful not to mix concepts here.
Assuming your Analysis Server is on-premises you will definitely need a gateway. The connection details must match exactly between dataset and gateway.
Right. thanks.
Analysis Services is not on premises. It is out on the internet. Which is why the connection string is using HTTPS:// for the data pump
When creating the OLE DB connection in Desktop Power BI, then internally Power BI seems to change the connection string from an OLE DB connection to AnalysisServices().... instead... which breaks when trying to publish and refresh