How to deploy PowerBi model in Azure?

[KasperJ90]

Hi,

I have a data warehouse (SQL) where I get data to my Power BI desktop. When I made a tabular model in Power BI I want to save it and deploy to azure analysis services. Then other people can add data to Power BI or Excel via Azure analysis services and my deployed model. This secures we have standard models and when I want to change something I add it to the model and deploy again. Can I do this?

[v-luwang-msft]

Hi @KasperJ90 ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @KasperJ90 ,

You could refer the following article ,and check if it is helpful，it tells steps to Connect Microsoft Azure to Power BI and ste-s include in publishing POWER BI DESKTOP file to azure.Wish it is helpful for you!

https://www.epcgroup.net/how-to-publish-power-bi-reports-to-azure/ 

Best Regards

Lucien

[amitchandak · Accepted solution]

@KasperJ90 , This was discussed some time back - not a complete solution - https://www.youtube.com/watch?v=n3iTkN3oNvw

Power Bi dataset can also be used by other power bi files, Excel (XMLA end point is available)

[KasperJ90]

@amitchandak thank you - seems like there will be a solution for this in the future. Let me add a few more words on why I ask the question, maybe you can help with current best practices. We are 2 people in an organization during BI for +50 end users. These end-users should not do any code/modeling but only use what is available in Excel/PowerBi. Soon we will have a Datawarehouse running Azure with tables from our current SQL server with our ERP system Navision. So we need a way we can control what we deploy to the organisation and provide them with a link on how to acess the data in PowerBi or Excel besides the standard reports we are sharing. My idea was we could provide a tabular model in PowerBi, save the file and deploy to Azure. Then the +50 end-users could acess the model from Azure. What can we do instead? Thanks a lot for your time.