Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So, I've installed an Enterprise On-Prem Data Gateway to a SQL server and successfully connected to PowerBI. When I go into "manage gateways" the connection says good to go and the SQL data source also says connection successful. However, when I change the data source in my report, it cannot find the SQL server. I've checked to make sure everything matches correctly multiple times and it does, I just cant seem to get it to connect. Any suggestions?
Can you confirm you did the following
1. Power BI Service > Manage Gateways > Select your gateway > Gateway Cluster settings tab > you see the message "Online:You are good to go"
2. Power BI Service > Manage Gateways > Select your gateway > Select your data source (the SQL Server in your case) > Data source settings tab > you see the message "Connection successful"
3. Open Power BI desktop > get data > SQL Server > connect to SQL server and get some data (or make sure your current report connects to the SQL Server from the desktop). I would use a new report just to check if it is working.
4. Create some tables and visuals and publish it to Power BI Service.
5. Power BI Service > Got to workspace where the report was published > dataset of the report > More (the three dots) > Scheduled refresh > Gateway connection and see if you can see the gateway. You should be able to select the gateway. It will take a while (about 15 seconds) to connect sometimes.
Let me know how it goes.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.