How can I obtain the Power BI IP range to authorize in Azure SQL in the Brazil South region?
Hello, I'm new to Power BI and I'm facing an issue when trying to allow access by IP address to Azure SQL. I created a firewall rule to permit access from a specific IP, as indicated in the error message I received. However, I've noticed that Power BI IPs change periodically, which requires me to constantly update the list of authorized IPs. My question is: how can I obtain the IP range used by Power BI in the Brazil South region, in order to ensure more stable and secure access to Azure SQL? I would like to ensure that my environment continues to function smoothly, even with variations in Power BI IPs. I appreciate any guidance or information on how to address this issue.Which IPs should be whitelisted to allow data refresh
Dear PowerBI community, Since last week, my organization started whitelisting IP addresses to increase security. However, since this initiative, multiple PowerBI reports of various firms we make reports for are not refreshing anymore in PowerBI service and also in the desktop version. Most PowerBI reports we build for other firms still work normal, with automatic data refreshes. This indicates that the problem is likely not influenced by the data gateway, as this is the same for the working reports. The error message I receive for the reports that do not work anymore in PowerBI desktop is as follows: "[DataSource.Error] Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. [DataSourceKind = \"SQL\"]. I am wondering how I can find out which IP addresses I need to whitelist to solve these issues. When I opened the developer tools window in Chrome and looked for IP addresses when I refreshed my reports, I discovered that the request URL WABI-NORTH-EUROPE... has a remote IP address of 20.38.84.XXX. As I believed this was the IP address used by PowerBI to retrieve the data (via Azure?), I whitelisted all IP addresses in the range of 20.38.84.000 - 20.38.84.255. However, this was not effective. Do you have any advice on how I can find out which IP addresses I need to whitelist to solve my data refresh problems? Thank you a lot in advance! Jeffrey
Power BI configuration - sending Internal IP Address to client browser
Good afternoon. We are trying to secure our implementation of Power BI server. When a client requests the server, in some of the responses, the internal ip address is shown, for example: {"@odata.context":"https://xxx.xxx.xxx.xxx/Reports/api/v2.0/$metadata#Me","Id":"yyyyyy-zzzz-xxxx-eeee-kkkkkkkkkkkk","Username":"user_name","DisplayName":"user_name","HasFavoriteItems":false,"MyReportsPath":null} Does anyone know how to get this to stop sending the IP address and send a name instead? Thanks, Gene
