Forum Discussion

luiscontrerasdo's avatar
luiscontrerasdo
Regular Visitor
7 years ago
Solved

Looking for recommendations

Hi,   Having the following scenario: Windows 2012 + SQL Server 2016 Enterprise + Microsoft Power BI RS  A table name data with the fields (id, salesid, amount) From End User side: Windows 10 +  P...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    luiscontrerasdo,

    Do your end user have Power BI Service account? If so, you can connect to SQL Server database in Power BI Desktop , create report in Power BI Desktop and publish the report to Power BI Service, there is an article for your reference..

    Then you can install gateway on your server, add the SQL Server data source within gateway following the guide in this article, and set schedule refresh for your dataset in Power BI Service. After that, you can share the report to your end users.

    However, if you need to set schedule refresh in Power BI Report Service, please review this article.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

luiscontrerasdo,

Do your end user have Power BI Service account? If so, you can connect to SQL Server database in Power BI Desktop , create report in Power BI Desktop and publish the report to Power BI Service, there is an article for your reference..

Then you can install gateway on your server, add the SQL Server data source within gateway following the guide in this article, and set schedule refresh for your dataset in Power BI Service. After that, you can share the report to your end users.

However, if you need to set schedule refresh in Power BI Report Service, please review this article.

Regards,
Lydia