Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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)

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)

@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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.