Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi!
Does anyone know a good guidebook, video, etc how to publish Excel workbooks to Sharepoint Online (not SP 2013 etc). Excel workbook uses a Power Query-connection and this workbook needs to refresh data daily via Power Query (tabular model). I need a step-by-step-guide to a newbie : )
Solved! Go to Solution.
Hi @tuulia ,
Sorry, automatic refresh daily in SharePoint online is unavailable. You can use Refresh when opening or periodically refreshing:
Refresh an external data connection in Excel
Also check out these topics:
Excel web part from list - Autorefresh - SharePoint Stack Exchange
How to autorefresh Pivot table in Excel web access webpart in sharepoint
Also check supported connections and schemes:
Work with external data in Excel Services (SharePoint Server)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tuulia ,
Hope this video helps you:
Import Excel Data to a SharePoint List | Microsoft SharePoint - YouTube
In this video the vlogger shows you how to create a SharePoint list from data imported from an Excel spreadsheet.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! I must use a Power Query-connection (live connection to tabular model), so importing data is not an option...
Hi @tuulia ,
Sorry, automatic refresh daily in SharePoint online is unavailable. You can use Refresh when opening or periodically refreshing:
Refresh an external data connection in Excel
Also check out these topics:
Excel web part from list - Autorefresh - SharePoint Stack Exchange
How to autorefresh Pivot table in Excel web access webpart in sharepoint
Also check supported connections and schemes:
Work with external data in Excel Services (SharePoint Server)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, I'll check these options!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |