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

Refresh error - uploaded Excel workbook to Power BI service (Unsupported features)

Hi!

 

Background information

I have created an excel workbook which gets data from a SQL server. It is to be used to people in the organization who does not have access to the DW, but the data needs to be refreshed automatically. Moreover, they need to be able to print a nice pdf with company logo etc. Thus, it is not possible to do it in Power BI desktop . 

Therefore, I have uploaded the the excel workbook to sharepoint. I have uploaded the file to Power BI service by selecting corresponding Onedrive for the sharepoint team. It is now possible to open the excel workbook in the desktop app and print a pdf.

 

The excel workbook contains of a header with out company logo, a table which is filtered, two static cells with text, and a footer with page number.

 

The issue

The issue arises when updating the data. 

I get the below error message which I cannot understand. 

 

Something went wrong

Power BI cannot refresh this workbook because it contains features not supported in Excel Online. Open your workbook in Excel or Excel online to see a more detailed error message. Attempt to fix the issue, and then try to schedule refresh again.

Please try again later or contact support. If you contact support, please provide these details.

Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net

Activity ID: e73f3e58-eb20-4011-b200-520b2e053ef3

Request ID: da1d3b3a-ccca-cdbb-0d2a-394fad79eadb

Time: 2019-10-09 06:19:55Z

 

When opening the workbook in Excel, I do not see a more detailed error message.

 

Do anyone have an idea what might be the issue?

 

Any answer is very much appreciated.

 

Best regards,

Tobias

 

1 ACCEPTED SOLUTION

Accepted Solutions
TobiasRD Frequent Visitor
Frequent Visitor

Re: Refresh error - uploaded Excel workbook to Power BI service (Unsupported features)

The issue has been resolved

 

The issue was resolved by removing header and footer.

View solution in original post

1 REPLY 1
TobiasRD Frequent Visitor
Frequent Visitor

Re: Refresh error - uploaded Excel workbook to Power BI service (Unsupported features)

The issue has been resolved

 

The issue was resolved by removing header and footer.

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 163 members 1,904 guests
Please welcome our newest community members: