Forum Discussion

ludmil's avatar
ludmil
Frequent Visitor
8 years ago

Latest Power BI Android app can't render sql mobile reports having cached on the server datasets

Hi, We have a few mobile reports created with SQL server mobile publisher and hosted on Power BI Report server. They work fine on the server web portal and Power Bi android app as far as their datas...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi ludmil,

 

Can you get the same result when you test on other devices? Please share more detail contents about your operations.

In addition, you can also submit support ticket or contact to mobile team for further support

 

Regards,

Xiaoxin Sheng

ludmil's avatar
ludmil
Frequent Visitor
8 years ago

Hi Anonymous,

 

Yes...it behaves the same way on tablet...haven't tried on iPhone. We are doing pilot on the new Power BI Report server and the environment is pretty straightforward.  Actually this is not only performance problem but also could become design one when you have situation where portal KPIs and mobile reports use the same shared datasets. In order KPIs to refresh you need to set cache refresh plan ...but if you do then the mobile reports doesn't work. 

 

I found another similar note at https://docs.microsoft.com/en-us/sql/reporting-services/mobile-reports/get-data-from-shared-datasets-in-reporting-services-mobile-reports  (see the comments to the article)

 

Regards,

Ludmil

  • Lola's avatar
    Lola
    Frequent Visitor
    8 years ago

    Have the same issue with SSRS Mobile reports on Android app: ones the dataset on SSRS reporting server is pre-cached, Android is not able to render report.

    But iPhone/iPad is working very well with pre-cached datasets.

     

    For now have to set option to do not cache datasets, to allow Android to work. This is not good for performance... every time report opens - requesting the data.

    I have reports connected to SSAS-based datasets, and cubes updating daily. So the daily cache is the best way, as the data is not changing during the day, and no reason to ask fresh data all the time from all devices...

     

    Had email communication with mobile team about this problem, they confirmed that this is known issue. 

     

    Hope that this issue will be solved... To buy iPhones for everyone is not a solution...