Exportable Report

[southcali12]

Hi,

I'm trying to figure out if there is a way to separate the Power View from the actual workbook. I want to email out the Power View report only, without having to email them the workbook containing the raw data. Any help would be greatly appreciated. Thanks!

 

[SimonNU]

PowerBI appears to be the perfect solution to your problem. Alternatively, you can look into SSRS but it's much​ more difficult to setup.

 

[southcali12]

Yup! That is the current process I have been using. However, the reports I create in PowerBI don't properly show the relationship that is created in my Power View. For example, I want things to cross over between two tables based on their date in PowerBI but the second table's data never carries over into the report.

 

[SimonNU]

Well, I don't know why that is...

Another alternative is to upload the Power Pivot (or PowerBI) data model to an SSAS Tabular environment and then recreate the Power View report using the cube as a data source. This way, you can email out the workbook without the data in the background yet still allow users to interact with the report.

 

[southcali12]

Thank you!