Forum Discussion
Solution about snyc database from SQL Server to Azure, after that create and public dasboards
HI CongPham ,
#1, For sync database from on-premises to Azure, you can refer to the following document if it helps. BTW, you can also post this to Azure community to get further support.
Tutorial: Set up SQL Data Sync between Azure SQL Database and SQL Server on-premises
#2, It is similar to get data from SQL service database, you only need to use Azure SQL connection string on SQL connector.
Power BI Get Data: From Azure SQL Database
#3, For share features, you can take a look at the following links:
Share Power BI dashboards and reports with coworkers and others
Embedded analytics with Power BI
Notice: share feature require Pro license, if your users do not have Pro license, you can consider using 'publish to web' feature which not require Pro license. (it contains a few limitations and no security setting enabled 'publish to web' reports)
Regards,
Xiaoxin Sheng
HI CongPham ,
#1, Yes, Pro license cost 10$ per month. BTW, if your organization has requirement for office subscriptions, you can also consider purchasing office 365 enterprise subscriptions, it provides some power bi Pro licenses as gifts.
#2, It can be used to share power bi content but it requires user has pro license except you assign them to premium capacity.
#3, I'm not so familiar with detail operations steps, maybe you can post to Azure forum or open a support ticket on azure side to get further support.
Regards,
Xiaoxin Sheng
Many thank Mr Anonymous
But I still have some questions:
1. We will user Pro license for each developer and viewer. I think it costs about 100$ per month for 10~12 people, doesn't it?
2. About Embedded analytics with Power BI , I dont know what it means, because our purpose is create dashboard and the database is uploaded realtime.
3. Do you know more about #1: Snyc between SQL Database and Azure Database: everything need to prepared and how does it costs?
HI CongPham ,
#1, Yes, Pro license cost 10$ per month. BTW, if your organization has requirement for office subscriptions, you can also consider purchasing office 365 enterprise subscriptions, it provides some power bi Pro licenses as gifts.
#2, It can be used to share power bi content but it requires user has pro license except you assign them to premium capacity.
#3, I'm not so familiar with detail operations steps, maybe you can post to Azure forum or open a support ticket on azure side to get further support.
Regards,
Xiaoxin Sheng