Forum Discussion

rubendn's avatar
rubendn
New Member
10 years ago
Solved

Data Gateway "No Resources Found"

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 ...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    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

rubendn's avatar
rubendn
New Member
10 years ago

I'm trying to connect to our on-premise SQL Server.

 

This is what the data source settings look like...

 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

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