Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
The issue has been resolved
The issue was resolved by removing header and footer.
The issue has been resolved
The issue was resolved by removing header and footer.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.