Today I learned how to seamlessly integrate Excel Online with the Power BI service. The Excel PivotTable is connected live to a Power BI dataset and can be updated and customized in Excel Online.
You just have to keep in mind not to upload the Excel file directly to the service, but to connect it via OneDrive for Business or SharePoint.
Did you know it?
Are you already using this feature?
Let me know what you think about it and post it in the comments.
Many thanks to Ikechukwu Edeagu for leading me to the solution.
watch?v=x_-dELMucGQ
Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.
Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast
