Joyce Posted October 23, 2017 Posted October 23, 2017 Hi I am getting HTTP error 500' when I try to download/open a report. I have full 'Advance report Admin Role' on my profile, and was able to create, run and download before. Please advise how I can solve this issue.
TrevorKillick Posted October 23, 2017 Posted October 23, 2017 Sorry @Dan Munns @Joyce Can you try it again now please? Kind Regards Trevor Killick
Dan Munns Posted October 23, 2017 Posted October 23, 2017 @TrevorKillick Yep all seems to be working now
TrevorKillick Posted October 23, 2017 Posted October 23, 2017 @Dan Munns Brilliant sorry about that. Kind Regards Trevor Killick
Dan Munns Posted October 23, 2017 Posted October 23, 2017 @TrevorKillick Do we know what the issue was? I have people who were trying to run project related reports asking questions....
TrevorKillick Posted October 23, 2017 Posted October 23, 2017 @Dan Munns Yeah we recently made a change to how the reports are download, unfortunately defect that was not visible in development or testing slipped through, we will be amending our release process to prevent this type of issues from reoccurring. Kind Regards Trevor Killick
Joyce Posted October 25, 2017 Author Posted October 25, 2017 Thanks @TrevorKillick, I can now download the reports.
Joyce Posted October 25, 2017 Author Posted October 25, 2017 Hi @TrevorKillick, Will connection to the report through Power BI be affected? I am trying to connect from Power Bi to Service manager reports, using 'R Script', and it seems to be taking a very longtime, then get timed out. Thanks. Regards Joyce
TrevorKillick Posted October 25, 2017 Posted October 25, 2017 @Joyce No PowerBI Integration should not be effected. Do you get any further details or messages around the timeout? Kind Regards Trevor Killick
Joyce Posted October 25, 2017 Author Posted October 25, 2017 @TrevorKillick It just take too long to connect, could be because my report is too big. Is there as limitation on number of record in a report, which can be integrated in Power BI from SM? Regards, Joyce
Joyce Posted October 25, 2017 Author Posted October 25, 2017 my report has about 10000 records, I can easily download it to my desktop etc, I just cannot connect to it via Power BI. Thanks. Regards, Joyce
Steve G Posted October 25, 2017 Posted October 25, 2017 Hi @Joyce, If your report takes 30 minutes or more to run, then Power BI will timeout the R script. This is a limitation within the Power BI implementation of R, and cannot be changed. See this page for more information: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-scripts/ Due to this Power BI limitation, we have also provided an R script that will take a Run ID as well as the Report ID as its input parameters, which will then import data from report runs that have already completed. So you could point this at the report that the other R script initiated the run of, to get your data in to Power BI: https://github.com/hornbill/rPowerBIHornbillDataSources/blob/master/PowerBIDataSource_HistoricReport.R There is a post on the following forum, which describes the issue in more detail. This also allows Power BI users to vote on feature requests, which the Microsoft devs will then use to prioritise what goes in to Power BI. The more votes the better to get Microsoft to fix this odd limitation https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17885383-urgently-need-fix-for-r-script-timeout I hope this helps, Steve
Joyce Posted October 25, 2017 Author Posted October 25, 2017 my report is not that big. it takes 2 seconds to run, so it should not time out.
Joyce Posted October 25, 2017 Author Posted October 25, 2017 My script doesn't have a 'Run ID', where can I get that? is it the same as report ID?
Steve G Posted October 25, 2017 Posted October 25, 2017 @Joyce that's a strange one then, may be an issue connecting to the file storage. I'll give it a whirl from this end and let you know what I find. The Run IDs should be in the left-most column on your Report History:
Steve G Posted October 25, 2017 Posted October 25, 2017 @Joyce I'm able to fire and retrieve report data from Power BI against one of my Hornbill instances. Could you private-message me the actual timeout error that you are presented with please and I'll take a look?
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now