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 dataset has caching property "Always run this dataset with most recent data". At the moment the property is set to "Cache the copies of this dataset" the Power Bi android app can't render the report - it just permanently stays in loading state...the server web portal rendering works ok.

Any hint for the reason will be highly appreciated. Thx.

15 Replies

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