cancel
Showing results for 
Search instead for 
Did you mean: 

Can't publish app with only workbooks

Hi,

 

I cannot Publish an App that contains Excel Workbooks only. I get this error when I try:

Activity ID28a0207f-1d2a-4fd0-bc61-89831a37a99d
Request ID70448e20-8c4a-39e4-a2ca-732fa40f107c
Correlation ID337a3c86-1eb0-0b89-6b86-1467ef88dee1
TimeTue Apr 16 2019 13:44:32 GMT+0100 (British Summer Time)
Version13.0.9115.138
Cluster URIhttp s://w  abi-no rth-euro pe-redir ec t.analysis  .windo ws net
 
When I add a pbix report to it, it publishes just fine. Then I have to remove the pbix report and update the App and it then does what I wanted it to begin with.
I found a workaround, still it's a bit annoying bug.
 
Regards, Jarek
Status: Accepted
Comments
v-qiuyu-msft
Community Support

Hi @Jaroslaw,

 

Which app workspace do you use, old version or new version? 

Does the issue happen to all Excel Workbooks or only the specific one? 

 

I tested both in old version and new version app workspace, if there is only one Excel workbook, it's able to publish the app workspace as an app. Please test again on your side. Also you can test with this sample Excel workbook to see if the same issue occurs. 

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Needs Info
 
Jaroslaw
Frequent Visitor

Hi,

 

No problem with the Financial Sample data you linked.

The problem appears once the Excel file has data stored in Data Model.

 

1. Using this Financial Sample spreadsheet, go to Data -> Get and Transform - >From Table/Range.

2. Then "Close and Load to..." -> "only Create connection" and tick "Add this data to the Data Model".

3. Insert -> PivotTable -> "Use this workbook's Data Model" and "New Worksheet". Then create a Pivot showing units sold by county (as an example). Save workbook.

4. Add to an emply App Workspace and try to publish it.

v-qiuyu-msft
Community Support

Hi @Jaroslaw

 

Thank you for detail information. I have reported this issue internally: CRI 116125438. Will update here once I get any information. 

 

Best Regards,

Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Accepted
 
v-qiuyu-msft
Community Support

Hi @Jaroslaw

 

I got information that this should be fixed by early this week.

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support

Hi @Jaroslaw

 

Please test again to see if the issue is fixed now. 

 

Best Regards,
Qiuyun Yu 

v-yuta-msft
Community Support

@Jaroslaw ,

 

Issue has been fixed currently.

 

Regards,

Jimmy Tao