PowerBI Excel session timeout error

[DougM]

Hi

I am trying to use the publish to Excel feature in PowerBI ... I have a 6Mb Excel workbook saved in Sharepoint Online, and published to PowerBI, all done with no error

Occasionally I am able to open it, but 80% of the time i get the error below:

• Continue interacting? We noticed that you haven't been interacting with this workbook, so we paused your session.
  Reload to get the latest version of the workbook

When I click reload I get the following error:

• Sorry, something went wrong. Could you please try that again? Error Id: 70f8812a-55a3-42cb-a843-9edeb05c1585, 2018-08-01 05:14:02Z

• When I click OK, I get the spinning wheel until I close down the browser

Any ideas appreciated

Thanks and Regards

Doug

[v-shex-msft]

Hi @DougM,

Did you means you are used 'connect' mode to get data from sharepoint on power bi service side? And it sounds like it has not used for a long time so it failed to load last data.

Any modifications on that workbook? If you create new connection to get date from that workbook, did this issue appears on new one?

If not, I think this issue should caused with power bi service features release and update so old version not compatible with new features.

Regards,

Xiaoxin Sheng

[DougM]

Hi

Thanks for the reply. I used the Get Data function to connect to the SharePoint site ... No modifications to the spreadsheet, and the failures occur immediately after upload

Regards

Doug

[v-shex-msft]

Hi @DougM,

Do you means you are get Excel workbook from sharepoint online at power bi desktop and publish to power bi service?

If this is a case, did this workbook store source data or a connection to external data source?

If your workbook is connect to external datasource instead source data, I think your issue may related to it.

Regards,

Xiaoxin Sheng