Import Mode Power BI Embedded

[luisvieira95]

Hi!

Recently our company has acquired the embedded version of Power BI, but we have not planed nor have budget to buy the azure sql DW to use live connection. We will refresh the data only one time or less per month, so we don't need a live data.

My question is, can I import a data model from our SQL Server local DB into a pbix and upload to power bi service to use this file (or files) as our power bi embedded file? 

Thank you for your kindness to respond this post.

[Jayendran]

Hi @luisvieira95 ,

Yes you can achieve that, you just need a gatway since you are going to use you local SQL DB, you need gateway.

After the gateway configuration you can setup the schedule refresh for the pbix file. Finally the data will reflect in your embedded pbi report