MizeelA Posted June 15, 2018 Posted June 15, 2018 Hi All, I am new to hornbill but my company is trying to report from Power bi using hornbill data. Following the link on wiki.hornbill https://wiki.hornbill.com/index.php/PowerBI_Reporting. I have managed to download the R script filled in the instanceName, InstanceZone, apikey, report ID and runid, added the code in the power bi editor but it seems that's not all I have to do. Also in this arrUrl do I have to fill in the instancezone and instance name? I have attached the error when I select connect to Power bi using R script (PowerBIDataSource_HistoricReport.R ) arrUrl = c("https://", instanceZone, "api.hornbill.com/", instanceName) Is it possible to get guide(step by step guide) on how this is created please? Regards Mizeel
MizeelA Posted June 15, 2018 Author Posted June 15, 2018 Hi I have now been installed all the packages via the CRAN repository, which connects correctly but It doesn't show any table under R folder. Am I missing something? I have attached a screenshot of the navigator from power bi. Regards Mizeel
TrevorKillick Posted June 15, 2018 Posted June 15, 2018 @MizeelA What do the first three lines of the .R script you are using look like Specifically these three: #Define Instance Details instanceName = "Instance Name Goes Here" instanceZone = "eur" Kind Regards Trevor Killick
MizeelA Posted June 15, 2018 Author Posted June 15, 2018 Hi Trevor, It looks like this #Define Instance Details instanceName = "Ammic" instanceZone = "eur"
Victor Posted June 15, 2018 Posted June 15, 2018 @MizeelA 1 hour ago, MizeelA said: instanceName = "Ammic" This is not a valid instance name... Also: 7 hours ago, MizeelA said: Also in this arrUrl do I have to fill in the instancezone and instance name? No. Those are variables, changing them will break the PowerBIDataSource_HistoricReport.R script. The only information you need to input is in the "#Define" sections: #Define Instance Details, #Define API Key and #Define Report details 1
MizeelA Posted June 25, 2018 Author Posted June 25, 2018 Hi , having issues scheduling a report in Power bi service after publishing from the desktop. Under the data source credentials it comes up with the below information. Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again. When I select the Edit credentials I am on unable to sign into the data-source of the report or change the authentication method from windows. My login and password is the same as for windows and in Hornbill. Am I missing something? Guidance will be much appreciated. Regards MizeelA
MizeelA Posted June 25, 2018 Author Posted June 25, 2018 10 minutes ago, Victor said: Perhaps @Steve G might be of assistance here? Hi Steve, any assistance will be much appreciated.
Steve G Posted June 26, 2018 Posted June 26, 2018 Hi @MizeelA, This appears to be an issue with Power BI in the cloud not being able to authenticate against your locally installed Power BI Gateway, which is required when scheduling the running of reports that get data using R scripts. You need to check the configuration of your locally installed gateway and ensure that Power BI in the cloud can communicate and authenticate with this. See the following pages from the Power BI website for more information: https://powerbi.microsoft.com/en-us/blog/visualizing-and-operationalizing-r-data-in-power-bi/ https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode Kind regards, Steve
MizeelA Posted June 29, 2018 Author Posted June 29, 2018 Hi @Steve G, Thanks for your response. You are right, Power BI authentication wasn't recognising the installed gateway (personal mode). After reviewing the pages from you and from Microsoft website , it seems to be a known issue with the personal gateway. The workaround available is as per below; 1. Open the On-premises Data Gateway (personal mode) desktop app on the machine where the gateway is installed. 2. Go to the connectors tab and switch off the Custom data connectors feature. 3. Click Apply -> Apply & Restart. 4. On the data-set page, click edit credentials and sign in. This resolved my issue and now able to schedule refreshes etc. Thanks for all your help @Steve G and @Victor . Kind Regards Michael 2
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