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

SSRS Drill Through issue

Hi

 

I have created two reports and the source of reports are SSAS 2016(Multidimensional Cube):

-> MainReport

-> DrillDownReport

 

In the Main report i have 3 SelectLists based on Market Dimesion:

Level 1: Region -> Burgenland, Salzburg, Niederösterreich, Tirol....

Level 2: District (filter based on Region. e.g Burgenland) ->  Mattersburg, Rust (Stadt) ....

Level 5: Customer -> 12345_xyz, 65432_abc, 99999_qwe

 

I have configured the drillthrough in the MainReport and passing the selecteditem (Region or District or Customer) as a parameter. The drillthrough works fine untill and unless the selectedItem is without any special character (Umlaut, whitespace, "(", underscore etc)

 

I am getting the following error message if i select "Niederösterreich" OR "Rust (Stadt)" OR "99999_LastName" OR "Neusiedl  am See":

 

"The mobile report could not be loaded.
The report may be incorrectly configured, data is unavailable, or the server version may not be supported."

 

Has anyone encountered with similar error?

 

Thanks!!

Neena

 

 

 

 

 

1 REPLY 1
v-qiuyu-msft
Community Support
Community Support

Hi @Neena,

 

Is there any issue when you run the main report in report builder or SSDT then click the actioned cell to drill through report? 

 

Does this issue occurs in Power BI report server? If it does, how about the result after you update the Power BI report server to August Preview version? 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!