Forum Discussion
Unable to render mobile reports in Power BI Android or iOS app that work fine.
My organization uses the new mobile reports. These work fine from the web portal and use to work fine in the Power BI ios and android application.
Now all of a sudden they spin forever and never load. They still work fine from the web portal. They are very small concise reports with small amounts of data being loaded. I can't imagine that the Power BI app is being overwhelmed.
Did something happen? Is this a known issue?
I have seen some other similar issues, but am not sure if this is the same issue. I apologize if this is a repost.
Happy that we could help here. Thanks for helping use troubleshooting this issue!
We would add this to our documentation.
28 Replies
Hi all,
After working with Microsoft on this, we have identified the issue and found a solution to get the mobile reports to render on Android.
The issue was identified by looking at the SSRS Log files located in C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles. We reviewed the logs captured during the timeframe that the app was being tested on the Android device and came across this error:
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!4a1!12/05/2016-14:21:42:: e ERROR: [5fu669ij]: XSRF Failed (NonceCookieNotFound)
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!4a1!12/05/2016-14:21:42:: i INFO: [5fu669ij]: 10.160.6.250: POST /api/v1.0/CatalogItems%28525798b3-88a3-446a-b8c4-66831b481c51%29/Model.DataSet/Model.GetData - Response 403 - 0:00:00.0014077
The error appears to be related to a domain name resolution problem as pointed out here.
We tested changing the connection to the server to the fully qualified domain name and were able to get the mobile reports to render. We also tested with the IP address of the server and were able to view the reports as well.
Hope this helps!
-Victor
Happy that we could help here. Thanks for helping use troubleshooting this issue!
We would add this to our documentation.
On Android I do get the error message "An error has occured, please try again." but on iOS nothing. They both continue to spin the loading graphic endlessly.
Sorry for the inconvenience. Are you referring to SSRS mobile reports?
Any specific data set? locale? What version are you using?
Yes SSRS Mobile Reports.
The data sets are hosted on the same sql instance (N/A US exterprise x64 2016 - v13.0.1601.5) as reporting services and are simple stored procedures. Nothing fancy.
The Power BI apps are the latest version from both the iOS and Android app store.
The SSRS web portal still runs fine but not a single report works through the app on any mobile platform. I really liked having our users using the Power BI app for simplicity.
I've tried creating brand new mobile reports from scratch. If I create a mock-up with no data connections this renders fine in the Power BI app. However if I pump even the smallest amount of data to it from a stored procedure the mobile reports no longer function in the app.
We are experiencing the same problem and would like to find a solution. To date nothing we have tried resolved this.
Are you seeing simular symptoms? (The apps worked, but stopped working after a recent update?)
If so, can you please also help us with the questions I posted above?
- Since when did you start seeing the problem?
Since we deployed the reports (10 Sep 2016)
- What's your SSRS 2016 and mobile report publisher versions? Did you install any updates for these products lately?
SSRS 13.0.1601.5
Mobile publisher build - 1.0.3836.0
No updates applied
- What's your Android OS version? Are you able to see the reports if you try to access the portal using your phone's browser?
Android version - 5
Can see the reoorts, they just don't render
- Are you passing any parameters to your datasets?
Do you see the problem repro on all datasets? (e.g. can you try defining a dataset that does a simple SQL query instead of running a stored procedure?)
Some reports work and some don’t, all reports use Stored Procs
- If you create a KPI using the same stored procedure? Does the KPI show ok?
Did not test this
- What type of authentication are you using?
AD authentication via the Power BI app
We are having the same problem. The sample reports work just fine. Reports that just use the "SimulatedTable" don't have a problem. But any reports that connect using an data sources and datasets we have created don't work.
Any updates on this issue? I was able to get report access for "SimulatedTable" but not for reports with data sources/sets. The reports render fine in iOS.
