cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KasperJ90
Helper III
Helper III

How to deploy PowerBi model in Azure?

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?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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)



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

View solution in original post

4 REPLIES 4
v-luwang-msft
Community Support
Community Support

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
Community Support
Community Support

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
Super User
Super User

@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)



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

@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.

 

 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.