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.
I'm trying to connect to data source which is our local SQL Server.
1) I downloaded and installed the On-premises data gateway application on one of our servers that has access to the SQL Server
2) After installation, I can see the gateway under "Manage Gateways" in Power BI Web and it says "Online. You are good to go."
3) I added a data source and it shows "Connection Successful"
4) When I try to add a dataset by clicking the +, then Databases, then SQL Server Analysis Services, then Connect, I get "No Resources Found" (Screen shot below).
5) Any ideas? I'm using the same login I used to setup the on-premise gateway to login to Power BI Web.
Solved! Go to Solution.
Hi @rubendn,
If you want to get data from the SQL Server database, you need to create a .PBIX file in Power BI Desktop, which uses data from SQL Server database. Then publish the .PBIX file to Power BI Service. And configure the SQL Server data source in data gateway which you have done to make sure data refresh. For more information, please take a look at this article: Databases.
Best Regards,
Qiuyun Yu
Hi @rubendn,
In your scenario, if you want to connect to SSAS data source, you need to configure SSAS data source in your gateway firstly. Please go to Manage Gateways, and check if you have added SQL Server Analysis Services data source.
Reference:
SQL Server Analysis Services live data in Power BI
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
I'm trying to connect to our on-premise SQL Server.
This is what the data source settings look like...
Hi @rubendn,
If you want to get data from the SQL Server database, you need to create a .PBIX file in Power BI Desktop, which uses data from SQL Server database. Then publish the .PBIX file to Power BI Service. And configure the SQL Server data source in data gateway which you have done to make sure data refresh. For more information, please take a look at this article: Databases.
Best Regards,
Qiuyun Yu
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.