Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
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?
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingWe 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |