Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
with powerbi desktop on local I install R environnement. Script OK (powerquery) and no issue.
I publish this report to powerbi service. I have parametered the update daily. But i have an issue with gateway with R.
What could i do???
Thank u all
Solved! Go to Solution.
Hi, @Soutteman
It seems like you are having an issue with the gateway when refreshing your report in Power BI service. There could be several reasons why this is happening, but one common cause is that the gateway is unable to communicate with the data source over HTTP.
To troubleshoot this issue, you can start by checking if the gateway version is up to date. If it has not been updated for a month or longer, you may want to consider installing the latest version of the gateway and see if you can reproduce the issue.
You can also test the connectivity from the gateway to the Azure Service Bus by running some PowerShell commands. If everything is OK, you should get a TcpTestSuccedded = True. If the firewall is blocking the connections that the Azure Service Bus makes to the Azure data centers, you will want to add the IP addresses for your region for those data centers to allow list.
If the issue persists, you can collect gateway logs. In the On-premises data gateway user interface, select Diagnostics and then select the Export logs link near the bottom of the page. Review the latest gateway logs and look for Proxy, Authentication, and Timeout errors.
If you are still having issues, you can check if the gateway is installed in the same region/cluster as your data source. You can also try logging into the Power BI Service using the In-Private Browsing or in Chrome Incognito, so that you don't use the cached information. Then, click on the gear icon in the upper right and select Manage Gateways. Click on Administrators and add the account that needs to be able to manage the Data Gateway in the Power BI Service.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have a report with a script in R and also in excel,but I can't connect the gateway to the R script, does anyone know how to make it work?
Hi, @Soutteman
It seems like you are having an issue with the gateway when refreshing your report in Power BI service. There could be several reasons why this is happening, but one common cause is that the gateway is unable to communicate with the data source over HTTP.
To troubleshoot this issue, you can start by checking if the gateway version is up to date. If it has not been updated for a month or longer, you may want to consider installing the latest version of the gateway and see if you can reproduce the issue.
You can also test the connectivity from the gateway to the Azure Service Bus by running some PowerShell commands. If everything is OK, you should get a TcpTestSuccedded = True. If the firewall is blocking the connections that the Azure Service Bus makes to the Azure data centers, you will want to add the IP addresses for your region for those data centers to allow list.
If the issue persists, you can collect gateway logs. In the On-premises data gateway user interface, select Diagnostics and then select the Export logs link near the bottom of the page. Review the latest gateway logs and look for Proxy, Authentication, and Timeout errors.
If you are still having issues, you can check if the gateway is installed in the same region/cluster as your data source. You can also try logging into the Power BI Service using the In-Private Browsing or in Chrome Incognito, so that you don't use the cached information. Then, click on the gear icon in the upper right and select Manage Gateways. Click on Administrators and add the account that needs to be able to manage the Data Gateway in the Power BI Service.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Team _Charlotte,
i've updated the gateway and open the TCP , and it works fine !! 🙂
Many thanks to you!
Regards,
Nicolas
More inforamtion, my database is on Azure
User | Count |
---|---|
38 | |
16 | |
13 | |
11 | |
9 |
User | Count |
---|---|
53 | |
31 | |
22 | |
18 | |
15 |