cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

SAP BW DirectQuery URL Parameters

Has anyone successfully sent URL parameters to SAP BW DirectQuery reports?

 

In the following example,

1. The The filter is added to the Report-Level Filters, but the attribute is not being filtered.

2. "Aug" is a correct member Name.

3. I've also attempted to send the member Key and UniqueName and using the Technical names, to no avail.

 

Example filter sent with the URL:

.....?filter=Posting_x0020_period/Posting_x0020_period_x0020_Level_x0020_01 eq 'Aug'

 

Resulting filter added:

BW Problem.PNG

 

Thanks!

Nathan

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: SAP BW DirectQuery URL Parameters

@v-xicai  - 

Thanks for your help. I've realized the issue is different that what I'd thought. I posted an issue here.

Thanks,

Nathan

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: SAP BW DirectQuery URL Parameters

Hi @natelpeterson ,

 

From the first link https://docs.microsoft.com/en-us/power-bi/service-url-filters#filter-on-multiple-fields, we know the dynamic URL filter have the structure : URL?filter=Table/Field eq 'value' , and it is different for reports in apps, you need to add " &'ctid=ctid " in the end, that will be

the structure: URL?filter=Table/Field eq 'value' &'ctid=ctid .

 

Special characters and spaces require some additional formatting. When your query contains spaces, dashes, or other non-ASCII characters, prefix those special characters with an escape code starting with an underscore and an X (_x), then the four-digit Unicode, then another underscore. If the Unicode is fewer than four characters, you need to pad it with zeroes. See more detail: https://docs.microsoft.com/en-us/power-bi/service-url-filters#special-characters-in-url-filters.

 

Identifier

Unicode

Coding for Power BI

Table Name

Space is 0x20

Table_x0020_Name

Column@Number

@ is 0x40

Column_x0040_Number

[Column]

[ is 0x0058 ] is 0x0050

x0058_Column_x0050

Column+Plus

+ is 0x2B

Column_x002B_Plus

 

Best Regards,

Amy

 

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

Super User
Super User

Re: SAP BW DirectQuery URL Parameters

Hi @v-xicai ,

Thanks for your reply. This report is not in an App yet. Here is the filter - does anything look wrong with it?:

 

?filter=Posting_x0020_period/Posting_x0020_period_x0020_Level_x0020_01 eq 'Aug'

 

The weird thing is that the field gets added, but it does not filter to August ('Aug'). I've verified that Aug doesn't have any addiional hidden characters. 

 

Thanks,

Nathan

Super User
Super User

Re: SAP BW DirectQuery URL Parameters

@v-xicai  - 

Thanks for your help. I've realized the issue is different that what I'd thought. I posted an issue here.

Thanks,

Nathan

View solution in original post

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 322 members 3,276 guests
Please welcome our newest community members: