Forum Discussion
Power BI refresh query
1 yes
Edit: I haven't changed my answers below but I am now not so sure. I would like someone from MS to validate.
It is not clear to me if replication of data is included or if it is only direct connect. What happens when you try it?
https://powerbi.microsoft.com/en-us/documentation/powerbi-power-bi-pro-content-what-is-it/
2 yes and no. You need a pro license for this but it is because you are using a gateway
3 yes and no. As above, if you have a gateway you need a pro licence. But only for the person administering (I believe). Licenses are cheap and personally I consider it good to pay for things you value, especially when it is cheap. Optionally you could use a product like Power update http://xbi.com.au/update to refresh loacally and automatically push the pbix to the server. This software costs $500 + 20% maintenance so a single power bi licence is still good value.
Hi Anonymous,
Sorry for the delay response.:smileyhappy:
On the on-prem gateway point - is this the same where data is pushed to Azure? I.e. If the data source was an Azure-hosted database which Power BI connects to to refresh itself automatically/nightly - would this still require all users of the dashboard to have a pro license to view the dashboard's content?In this scenario, no gateway is needed to connect to Azure Databases. However, Pro license is still needed.
Regards
1 yes
Edit: I haven't changed my answers below but I am now not so sure. I would like someone from MS to validate.
It is not clear to me if replication of data is included or if it is only direct connect. What happens when you try it?
https://powerbi.microsoft.com/en-us/documentation/powerbi-power-bi-pro-content-what-is-it/
2 yes and no. You need a pro license for this but it is because you are using a gateway
3 yes and no. As above, if you have a gateway you need a pro licence. But only for the person administering (I believe). Licenses are cheap and personally I consider it good to pay for things you value, especially when it is cheap. Optionally you could use a product like Power update http://xbi.com.au/update to refresh loacally and automatically push the pbix to the server. This software costs $500 + 20% maintenance so a single power bi licence is still good value.
GuyInACube Adam can you clarify if once per day replication to onpremise sql server using a gateway I suggest pro content. It is not clear in this blog post. https://powerbi.microsoft.com/en-us/documentation/powerbi-power-bi-pro-content-what-is-it/
Can you also coordinate to have the article updated to make it clear.
Thanks
Matt