PowerBi issue

[RyanMesser]

Hi,

A couple of issues I have with trying to pull a report with R in PowerBi using one of your scripts from github. If I keep in the line if(runID > 0)  it tells me the argument is of the length of zero when the report has been run 3 times previously. 

If i take that line out I get further but then I get - Error in grepl(runStatus, "completed") : invalid 'pattern' argument 

Thanks

Ryan

[James Ainsworth]

Hi Ryan,

Could you do a quick check to see if you are on the latest version.  There was an update on June 28th.  This may not fix your issue but always worth checking, just in case. The current version is 1.1.0

Regards, 

James

[RyanMesser]

Hi James,
Version of what Power Bi or R?

Thanks

 

Ryan

[RyanMesser]

Hi James,

I'm on version 1.1.0 of PowerBi.

Thanks

Ryan

[RyanMesser]

I assume its something to do with the runID, the only reason I can see that the script returns "argument is length of zero" is if runID input is the length of zero? I don't know if that parameter has changed but the only reason I can see why it says what is says. 

[James Ainsworth]

Hi @RyanMesser

Sorry, my post wasn't very clear.  It was the version of the Hornbill script available no https://github.com/hornbill that I was suggesting having a look at.  

[RyanMesser]

Hi James,

No worries yes that's the version of script I'm using in which I get these errors.

Ryan

[Victor]

@RyanMesser - in your script, what is the configuration/values for reportID and reportComment please?

Can you also PM me the API key...

[RyanMesser]

@Victor I have PM'd you.

Ryan

[RyanMesser]

Hi, 

Still having the same issue, tried creating the a blank report (no filters or anything) and trying to run powerbi  but exactly  same error.

Ryan 

[RyanMesser]

All,

Worked out that the API key wasn't authenticating so I created a new one and it ran fine, i guess this is why the runID was returning NULL which is what the argument is length of zero means. 

Thanks

Ryan

[James Ainsworth]

Hi @RyanMesser

Thanks for letting us know that you found a solution to this and sorry that we were not able to help.  This post can help other customers that might run into the same issue to great to have your solution posted.

Regards,

James