cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tinadouglass51
Frequent Visitor

Excel live connect to analysis services

Hi, 

 

We have power bi sales reporting dashboards/reports and are using the cube/model to live connect in excel.  

 

What have others done to share these excel reports with sales people in the business and distributed changes to reports as they are needed? The excel reports are currently stored in Sharepoint.

 

Tina

 

 

4 REPLIES 4
v-lili6-msft
Community Support
Community Support

hi  @tinadouglass51 

For your case, you 'd better share the dataset with others directly or share the report/dashboards.

https://docs.microsoft.com/en-us/power-bi/service-datasets-share

https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
edhans
Super User
Super User

why wouldn't you share the Power BI reports? Putting Excel into the mix can cause another point of failure, security issues, etc.

 

I guess the question is, why are you using Excel to share Power BI cubes?



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

We have a consultant that built this before i was hired and my understanding is it was due to performance issues using Power BI (and maybe a bit of the comfort feeling of excel with the business).  They still use the dashboards for higher level analysis and KPI's.

 

 

Get that company on board with Power BI. I've used Power BI extensively in a small/medium sized business environment and have seen FAR MORE STABILITY in Power BI than anything in Excel using Power Query and Power Pivot. I am constantly moving solutions I've created in Excel to Power BI so it is automated and stable.

 

THen use  the Analyze in Excel connector for those solutions that must have Excel as an end-point. Like printing data to PDF - something Power Pivot and Excel are better at than Power BI is.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.