cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aithomas Frequent Visitor
Frequent Visitor

PBIDS - SAP BW Implementation 2.0

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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-alq-msft
Microsoft

Re: PBIDS - SAP BW Implementation 2.0

Hi, @aithomas 

 

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. 

 

d1.png

 

Best Regards

Allan

 

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

View solution in original post

2 REPLIES 2
Microsoft v-alq-msft
Microsoft

Re: PBIDS - SAP BW Implementation 2.0

Hi, @aithomas 

 

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. 

 

d1.png

 

Best Regards

Allan

 

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

View solution in original post

aithomas Frequent Visitor
Frequent Visitor

Re: PBIDS - SAP BW Implementation 2.0

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...

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors