Exporting Your Data - What Are You Doing?

We are using all three aspects of Power BI. I’ve created a pretty robust data model in PowerBI Desktop, which I publish to PowerBI.com for Report/Dashboard development and consumption by the organization. The Azure database is accessible to anyone in the organization to connect to in Excel as well provided they have the db username and password. That way, they can create Excel based stuff separate from the PowerBI Data Model. They can also connect to the Data Model in Excel via the Analyze in Excel functionality on PowerBI.com.

Brian,

I’m so glad to hear that you have worked this out.  I know that going from “On Premises” to RAMP hosted Tessitura meant a bunch of changes for you. 

When you say Power BI what parts of Power BI are you using.

• MS Excel (Power Query, Power Pivot)
• Power BI Desktop
• MS Power BI web site

Would love to hear more about some of your successes…

--Tom

…

718.724.8135

tbrown@BAM.org

From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Brian Ramos
Sent: Thursday, May 11, 2017 4:34 PM
To: Thomas Brown <tbrown@bam.org>
Subject: Re: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing?

We at Opera Philadelphia have started using PowerBI with great success! We are also on RAMP, and it took us many month to finally work out a way with the RAMP Team to push sql view data to an Azure Database that we connect to PowerBI. So we have just under 40 views that are scheduled to be pushed to Azure every morning. We are still working with Tessitura to figure out the best method to easily update the views if we want to add views or additional fields, but they are actively working on a solution for us to do that. Currently, if we need to make any of these changes, it requires us working with the consulting team and the RAMP team to update scripts and files.

I'm more than willing to share our views if you are interested in them.

We are using all three aspects of Power BI. I’ve created a pretty robust data model in PowerBI Desktop, which I publish to PowerBI.com for Report/Dashboard development and consumption by the organization. The Azure database is accessible to anyone in the organization to connect to in Excel as well provided they have the db username and password. That way, they can create Excel based stuff separate from the PowerBI Data Model. They can also connect to the Data Model in Excel via the Analyze in Excel functionality on PowerBI.com.

Brian,

I’m so glad to hear that you have worked this out.  I know that going from “On Premises” to RAMP hosted Tessitura meant a bunch of changes for you. 

When you say Power BI what parts of Power BI are you using.

• MS Excel (Power Query, Power Pivot)
• Power BI Desktop
• MS Power BI web site

Would love to hear more about some of your successes…

--Tom

…

718.724.8135

tbrown@BAM.org

From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Brian Ramos
Sent: Thursday, May 11, 2017 4:34 PM
To: Thomas Brown <tbrown@bam.org>
Subject: Re: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing?

We at Opera Philadelphia have started using PowerBI with great success! We are also on RAMP, and it took us many month to finally work out a way with the RAMP Team to push sql view data to an Azure Database that we connect to PowerBI. So we have just under 40 views that are scheduled to be pushed to Azure every morning. We are still working with Tessitura to figure out the best method to easily update the views if we want to add views or additional fields, but they are actively working on a solution for us to do that. Currently, if we need to make any of these changes, it requires us working with the consulting team and the RAMP team to update scripts and files.

I'm more than willing to share our views if you are interested in them.