Hi Adam, if you could put together a video on how to set up VNET data gateway I believe many people would find it useful as Azure networking can be tricky.
Hello Adam, it was a great video with multiple concepts in play and yes VNET config video would be great to have. One recommendation from me, more visuals would make understanding multiple coinciding easier :)
Great video, if I can connect and refresh the google bigquery data without a on premise gateway, does it mean the google bigquery not set to deny public access ? thank you !
most organizations already have an (API) Gateway in place... can you use TyK gateway or Kong Gateway to connect Power BI with your datasource? Or is that only possible with the Power BI Gateway.
Thanks Adam, this video really cleared things. We're currently working with a VNET gateway to get PowerBI to work with the data in our Azure SQL Database. But now we want to combine that with some data from SharePoint lists. In Power BI Desktop this works perfectly, but when publishing it to Power BI Services it is expecting to retrieve the SharePoint data from the VNET Gateways aswell. Is this even possible or should we work with an on premisse gateway over here?
Our organization will not allow us to enable all Azure Services to connect to our Azure SQL database. Can you do a video on how you can utilize service tags within the firewall rules to restrict access to PowerBi services only?
Hi Adam, What can I do to resolve gateway issues when I get a status message("Gateway or datasources not reachable) within the gateway connections,pls?
Thanks for the insightful video!!! I created a report which retrieves data from MySQL db. I managed to refresh the data in PowerBI Service by creating a Personal gateway, but when I am off the refresh schedules I've created do not run. I am getting "Your data gateway is offline"... Are there alternatives? :/
does the "on-premises data gateway" (opdg) have all the functionality of the "vnet data gateway"? its sounded like the opdg can connect to anything BUT the vnetdg can only connect to azure services. did i interpret that correctly? thx!
My architecture is based on push datasets. So, the new data is being pushed every 15 minutes to Power BI via APIs. And its sad that clients often cannot fully benefit from that data: calculated columns not allowed, merging with other data sources is not possible. It would be great to be able to connect a Power BI dataset with another Push Datasets.
I have an issue where I'm trying to use Excel Power Platform connection to Power BI service. The problem I have is that when I do this, it cannot see the workspace I created. Only stuff that is in "My workspace". We are trying to use excel to create a pivot table with the semantic model that consists of SQL server and Business Central data. I ended up having to use "My workspace" to deploy to Prod which is not ideal.
Hi Adam, how do I get limited data connecting from Power BI to Amazon Athena? Is a gateway needed or work with power BI to Amazon Athena? how to use Range Start and Range End with incremental refresh using data flows using Power BI to Athena?
Hello Adam I need to connect my Power BI Servicres to a Cloud SQL - CGP, but Power Bi would have to be authorized through an IP rule to allow it to access. Please tell me if this is possible and how it can be done. Thank you!
Hey can you create a video on how to create Vnet data Gateway in power BI. I am actually facing issue with connecting datasource to Vnet data Gateway that i have create. I am using Azure Database for PostgreSQL flexible servers with public Access
Hi Adam, very informative video as always. What is the best options to enable cross-tenant power bi data refresh as VNet data gateway will not work in that scenario? VNet data gateway currently only works if the Azure data source and PowerBi are on the same tenant unfortunately and will not work across the regions as well. I am working on a project where in we need to schedule data refresh from one organization's Azure SQL DB to one of thier clients Power Bi (B2B scenario). Our client (one with azure sql DB) does not have PowerBi and do not want to buy Power Bi lisence, hence in-place data sharing is not an option. In such scenario, what is the best option? Thank you in advance for your help.
in case we have to pass parameters for snowflake through api jobs then is it required gateway for snowfalke cause data is not refreshing but file is publishing through API (JENKINS JOBS)
Trying to connect to Athena right now and it's driving me mad. Guess I was spoiled by using BigQuery with Data Studio, but all these hoops we need to jump through feels ridiculous.
Hi adam, how to break this problem -> "Failed to update data source credentials: 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"
I would consider it a security vulnerability to enable "Allow Azure services and resources to access this server" because that applies to all Azure customers.
Hi Adam, great video as usual. I'm struggling with connecting to a firewall protected ADLS, getting a similar error as the one you're getting in the second case (the Allow Azure services on the trusted services list to access this storage account is enabled). The difference is we're getting this error as we try to connect from power bi desktop in a local machine using the AAD credentials (If we use the storage account key it works fine). Do you know why this might be happening? Thanks in advance!
thx Adam, very informative, as always. May we get a video on connecting to AWS RDS or on an EC2/Oracle Install? Trying to find an alternative to installing and registering oracle ODAC driver on my powerbi desktop. I am wondering if i set up the connection via PBI datamart, can i avoid the desktop step? many thx.
Hey there. I'm trying to build a "report of reports" and can't use the API because we don't use a report server, just the service in the cloud. Any ideas? Is this a problem that this sort of thing can solve?
I have a problem, power bi service on demand refresh works(refresh from desktop also works), but schedule refresh won't work(Azure db for Postgres is datasource) with an error: Failed to update data source credentials: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.' Can't even create new connection from service on same data source
Hi Adam, I have developer rights for Adobe but still unable to connect PowerBI to Adobe. Below is the issue This is likely a result of your account not being set up properly. Please contact Adobe for help setting up your account and then try again
I'd love to see a postgresql on azure set up.. Its one of those things that happily runs on a VM with PBi desktop, but once you try to get the service to manage the refresh the credentials just fail. I would also like to see how to get a local machine to connect using the postgresql connector in power bi desktop. I have installed the latest PBi desktop, stripped out every bit of superfluous dot net stuff on the machine but it just wont work. the VM works fine and I assume it's due to it being in the environment where the data source is, but I connect via VPN so it should work right? I can connect to the very same data using ODBC so why not posgtreSQL native connector? I can also connect using PGAdmin using odbc but cannot add the servers using postgreSQL method. Is there something missing from my local machine do you think? It's driving me nuts I must say.
OK, totally get the Power BI positioning, but what about online pivot tables consumed within Power BI ? Can connect to PPU models beautifully with full interactivity, but cannot connect to Azure or AS services even with a properly configured gateway. Is this supported and I'm doing / not doing something dumb ? If not supported, is it coming ? Power BI is not the full deliverable answer. Power BI with online Pivot Tables to the SAME datasources is !
Hi sir, I am facing connectivity issue from power bi to Azure databricks. This is the error: Details: "ODBC : ERROR [HY000] [ Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP Connection: SSL_Connect: Certificate verify failed.". Can you please help me in this issue.
Oh man, a thousand times that. How long is it gonna take for MS to make an universal gateway? The amount of workarounds we have to do to avoid gateways just because we can't put it inside a linux VM in cloud is absurd.
Hi Adam, if you could put together a video on how to set up VNET data gateway I believe many people would find it useful as Azure networking can be tricky.
This is exactly what I came here for, but it was skipped over so fast here I have no idea how to set it up :D
God Microsoft Sucks ass at vnet gateway set up. I despise them for this.
Yes please to the VNET config video.
Thanks Adam, this video helped me clear things up. I am most definitely interested in a new vnet-gateway setup video!
did not even knoew about the Vnet Gateway so love to know more.
Definitely a VNET video would be 👌
A vnet gateway video would be awesome 👍
Hi, can you make a video on how to set up schedule refresh for power bi dashboards that use salesforce objects as data source
Hello Adam, it was a great video with multiple concepts in play and yes VNET config video would be great to have. One recommendation from me, more visuals would make understanding multiple coinciding easier :)
Big yes please to vnet gateway video!
a VNET set up video would be awesome! :)
Thanks Adam, does it works for Azure SQL Managed Instance as well ? I'm struggling on that
Hi.. Is there a way to connect Microsoft Power BI in fabric with Azure KeyVault and refresh data seemlessly
Did they ever create the VNET gateway video? Definitely interested!
Hi, you mentioned at the end the configuration with AWS/Snowflake. Do you have any video that shows more on that?
Thanks!
Marc
Hey @Kaztou did you find how to connect power BI gateway to database hosted in AWS?
Great video, if I can connect and refresh the google bigquery data without a on premise gateway, does it mean the google bigquery not set to deny public access ? thank you !
Fow aws cloud connectivity does the gateway need to be there on that particular aws machine only?
most organizations already have an (API) Gateway in place... can you use TyK gateway or Kong Gateway to connect Power BI with your datasource? Or is that only possible with the Power BI Gateway.
Thanks Adam, this video really cleared things. We're currently working with a VNET gateway to get PowerBI to work with the data in our Azure SQL Database. But now we want to combine that with some data from SharePoint lists. In Power BI Desktop this works perfectly, but when publishing it to Power BI Services it is expecting to retrieve the SharePoint data from the VNET Gateways aswell. Is this even possible or should we work with an on premisse gateway over here?
very good video. it's a more complex, yet important topic.
Thank you Adam. Could you please do a video on pause automated report when a database refresh fails? Thanks 🙏
Our organization will not allow us to enable all Azure Services to connect to our Azure SQL database. Can you do a video on how you can utilize service tags within the firewall rules to restrict access to PowerBi services only?
Can you cover AWS EC2 ?
Hi Adam,
What can I do to resolve gateway issues when I get a status message("Gateway or datasources not reachable) within the gateway connections,pls?
Hi Adam, what is the best way to manage to Giga bytes of gateway of logs? Is there any solution that we use for log mining?
Thanks for the insightful video!!! I created a report which retrieves data from MySQL db. I managed to refresh the data in PowerBI Service by creating a Personal gateway, but when I am off the refresh schedules I've created do not run. I am getting "Your data gateway is offline"... Are there alternatives? :/
does the "on-premises data gateway" (opdg) have all the functionality of the "vnet data gateway"? its sounded like the opdg can connect to anything BUT the vnetdg can only connect to azure services. did i interpret that correctly? thx!
My architecture is based on push datasets. So, the new data is being pushed every 15 minutes to Power BI via APIs. And its sad that clients often cannot fully benefit from that data: calculated columns not allowed, merging with other data sources is not possible. It would be great to be able to connect a Power BI dataset with another Push Datasets.
What a great explanation! As always.
Yes please VNET setup video 🎉
I have an issue where I'm trying to use Excel Power Platform connection to Power BI service. The problem I have is that when I do this, it cannot see the workspace I created. Only stuff that is in "My workspace". We are trying to use excel to create a pivot table with the semantic model that consists of SQL server and Business Central data. I ended up having to use "My workspace" to deploy to Prod which is not ideal.
Hi Adam
Please think about making a video about vnets
Itll be a huge huge help!!
Hi Adam, how do I get limited data connecting from Power BI to Amazon Athena? Is a gateway needed or work with power BI to Amazon Athena? how to use Range Start and Range End with incremental refresh using data flows using Power BI to Athena?
Hey man did you find how to connect power BI gateway to database hosted in AWS?
Please let me know how to setup the VNet gateway.....
Hello Adam
I need to connect my Power BI Servicres to a Cloud SQL - CGP, but Power Bi would have to be authorized through an IP rule to allow it to access. Please tell me if this is possible and how it can be done. Thank you!
I have a block on the company network. Is there an IP range that we have to open port 444?
Hey can you create a video on how to create Vnet data Gateway in power BI. I am actually facing issue with connecting datasource to Vnet data Gateway that i have create. I am using Azure Database for PostgreSQL flexible servers with public Access
Hi Adam, very informative video as always. What is the best options to enable cross-tenant power bi data refresh as VNet data gateway will not work in that scenario? VNet data gateway currently only works if the Azure data source and PowerBi are on the same tenant unfortunately and will not work across the regions as well. I am working on a project where in we need to schedule data refresh from one organization's Azure SQL DB to one of thier clients Power Bi (B2B scenario). Our client (one with azure sql DB) does not have PowerBi and do not want to buy Power Bi lisence, hence in-place data sharing is not an option. In such scenario, what is the best option? Thank you in advance for your help.
in case we have to pass parameters for snowflake through api jobs then is it required gateway for snowfalke cause data is not refreshing but file is publishing through API (JENKINS JOBS)
Trying to connect to Athena right now and it's driving me mad. Guess I was spoiled by using BigQuery with Data Studio, but all these hoops we need to jump through feels ridiculous.
Is there anyway to connect to DataMarts SQL database in the cloud? Seem like most cant authenticate with MFA.
Hi adam, how to break this problem ->
"Failed to update data source credentials: 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"
Would have liked to have seen the AWS example into the gateway.
Hey @Brahim_El17 did you find how to connect power BI gateway to database hosted in AWS?
Hi@@adityajagtap7590 I'm also looking for this solution?? please let me know if you got any......
I would consider it a security vulnerability to enable "Allow Azure services and resources to access this server" because that applies to all Azure customers.
Hi Adam, great video as usual. I'm struggling with connecting to a firewall protected ADLS, getting a similar error as the one you're getting in the second case (the Allow Azure services on the trusted services list to access this storage account is enabled). The difference is we're getting this error as we try to connect from power bi desktop in a local machine using the AAD credentials (If we use the storage account key it works fine). Do you know why this might be happening? Thanks in advance!
thx Adam, very informative, as always. May we get a video on connecting to AWS RDS or on an EC2/Oracle Install? Trying to find an alternative to installing and registering oracle ODAC driver on my powerbi desktop. I am wondering if i set up the connection via PBI datamart, can i avoid the desktop step? many thx.
Hey @yumyumhotsauce1 did you find how to connect power BI gateway to database hosted in AWS?
Hi can u post a video on how to connect power bi service to mongo DB atlas on aws
Hey there. I'm trying to build a "report of reports" and can't use the API because we don't use a report server, just the service in the cloud. Any ideas? Is this a problem that this sort of thing can solve?
datalake 2 with firewalls anyway?
V-net video please
watched your Gateway videos... but still can't get the connection to mySQL working :(
I have a problem, power bi service on demand refresh works(refresh from desktop also works), but schedule refresh won't work(Azure db for Postgres is datasource) with an error:
Failed to update data source credentials: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.'
Can't even create new connection from service on same data source
Hi Adam, need support on vnet data gateway
Hello Gentlemens, would you be kind and make a video on the topic, visualisation of 3D models into Power BI? Thanks
Great video, thanks
Hi Adam,
I have developer rights for Adobe but still unable to connect PowerBI to Adobe. Below is the issue
This is likely a result of your account not being set up properly. Please contact Adobe for help setting up your account and then try again
I'd love to see a postgresql on azure set up.. Its one of those things that happily runs on a VM with PBi desktop, but once you try to get the service to manage the refresh the credentials just fail. I would also like to see how to get a local machine to connect using the postgresql connector in power bi desktop. I have installed the latest PBi desktop, stripped out every bit of superfluous dot net stuff on the machine but it just wont work. the VM works fine and I assume it's due to it being in the environment where the data source is, but I connect via VPN so it should work right? I can connect to the very same data using ODBC so why not posgtreSQL native connector? I can also connect using PGAdmin using odbc but cannot add the servers using postgreSQL method. Is there something missing from my local machine do you think? It's driving me nuts I must say.
OK, totally get the Power BI positioning, but what about online pivot tables consumed within Power BI ? Can connect to PPU models beautifully with full interactivity, but cannot connect to Azure or AS services even with a properly configured gateway.
Is this supported and I'm doing / not doing something dumb ?
If not supported, is it coming ?
Power BI is not the full deliverable answer. Power BI with online Pivot Tables to the SAME datasources is !
Bit me by surprise. My org is discouraging gateways, but I pointed out you need them to download them from public web sites!
Yes please! -> VNET
Hi sir,
I am facing connectivity issue from power bi to Azure databricks.
This is the error:
Details: "ODBC : ERROR [HY000] [ Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP Connection:
SSL_Connect: Certificate verify failed.".
Can you please help me in this issue.
+1 on video for VNet gateway config video
Leaves the most complicated part of the video out. How to setup the VM.
For sure !
Video on vnet gw please
gateway should be multiplatform and able to run in linux
Oh man, a thousand times that. How long is it gonna take for MS to make an universal gateway? The amount of workarounds we have to do to avoid gateways just because we can't put it inside a linux VM in cloud is absurd.
it´s already in the cloud! why can´t it just work :-) :-)
Yes please to the VNET config video.