Forum Discussion

noircrk's avatar
noircrk
Frequent Visitor
2 years ago

Adding Analysis Services Connection to On-Premise Data Gateway

Morning gurus!  I have a semantic model in a premium workspace that uses the CData Sage PBI Connector.  I am able to add this as a datasource in a desktop file.  After publishing I get an error sayin...
Need Help
Martin_D's avatar
Martin_D
Icon for Solution Sage rankSolution Sage
2 years ago

Hi noircrk ,

 

The CData connector is an ODBC driver. If it is installed on your local machine it works for you to create reports in Power BI Desktop. If you want to refresh data in Power BI Service, the CData connecter has to be installed on the same machine on which the gateway is installed. Then you (or your admin) can set up the data source in the gateway settings in the web brwoser, then you can use it to refresh data.

 

If your dataset uses direct query mode - with the CData connector both is possible, import and direct query - then you also need to make your authentication setting decision in the gatewy settings, whether direct query should use one provided login for all users or the identity of the current user (SSO) to access Sage data.

 

BR

Martin

  • noircrk's avatar
    noircrk
    Frequent Visitor
    2 years ago

    Thank you for your review, Martin.  The semantic model will refresh in the service just fine.  My problem is when I add that model as a datasource in a different PBI file and publish to the service I cannot get that to refresh.  That secondary published file has the error for missing gateway and makes me add a Analysis Services connection to the on prim gateway.  These settings are the ones I'm struggling with.