Forum Discussion
Excel/ Power Query/ Pivot as a web part in SharePoint?
Hello, I think my question can pertain to Power Query, Pivot, and BI, but I am hoping to get a better understanding of which route is most efficient, accessible, and if there are any things that nee...
Hi Kerry,
If in brief, querying your data by Power Query add data to data model, add measures if necessary and publish the file on Power BI services as dataset. It will be refreshed automatically. On the top, build Power BI report directly in services using Web interface or better by Power BI Desktop. Report could be published on Sharepoint Online site as web part. However, Power BI Pro licenses are required for users if nothing changed.
You may check that blog https://www.linkedin.com/pulse/excel-power-bi-teams-unlocking-value-your-enterprise-data-wyn-hopkins/ by Wyn Hopkins - that's not exactly your case, but close to it.