PBIDS - SAP BW Implementation 2.0

[Anonymous]

Hi,

The ability to use PBIDS files to pre-populate connection details for users seems like a really useful feature. However, we're running into some issues with using it for the SAP BW Connector (using this: https://docs.microsoft.com/en-us/power-bi/desktop-data-sources#sap-bw)

Is it possible to specify the implementation 2.0 SAP Connector in a PBIDS file? At the moment this defaults to the implementation 1.0, which doesn't work for us.

Also, can other connector options such as LanguageCode be specified in the connector?

I've tried adding an options field but without success:

{ 
  "version": "0.1", 
  "connections": [ 
    { 
      "details": { 
        "protocol": "sap-bw-olap", 
        "address": { 
          "server": "XXXXXX", 
          "systemNumber": "00", 
          "clientId": "XXXX" 
        },
		"options": {
			"LanguageCode": "EN",
			"Implementation": "2.0"
		}
      } 
    } 
  ] 
} 

Many thanks,

Andy

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, It is unsupported that other connector options such as LanguageCode be specified in the connector. You should operate as the content what is included in the official document. 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks Allan, I thought as much - the attempt to add the options field was a bit of a stab in the dark, was just wondering if anyone knew of any more comprehensive documentation of the PBIDS format elsewhere, particularly as the linked documentation says: 

"The following code snippets show several common examples for PBIDS files, but they aren't complete or comprehensive."

I've added a feature suggestion here - if anyone else has the same requirement please upvote!
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39500521-pbids-files-allow-specif...