Forum Discussion
Data Gateway "No Resources Found"
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
Community SupportHi 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...
- v-qiuyu-msft
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
