Windows 10: POWER BI TO UPDATE SHAREPOINT LIST WITH NO DUPLICATES?

JosieUK · Sep 8, 2022

I'm needing to update a sharepoint list with an active POWERBI dataset. I've tried various different flows but it either uploads nothing and says its complete, or it updates just duplicates! and I've got it as set to 'if no then create item' but .. it doesn't do anything?Urgently need help - been trying to do this for months now

:)

Brink · Sep 8, 2022

Updates for Excel Services and BI in SharePoint 2016 on-premises

If your organization enables Excel Services for SharePoint to enable BI, we have some updates on what has changed with SharePoint Server 2016 BI. Updates include architecture changes to the SharePoint-based on-premises Microsoft BI Stack and how you can benefit from upgrading your BI farms to SharePoint Server 2016, SQL 2016 and Office Online Server with Excel Online. We also examine various aspects, such as upgradeability, backward compatibility and licensing. For more information, please read “Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016.”

First, let’s look at the history of Excel web solutions on-premises:

From the diagram above, you can see that Excel Services has evolved from an optional add-on application for SharePoint Server 2007 to an inherent part of Office Online Server for on-premises. In this newest 2016 release, Excel Services capabilities are moving to Office Online Server (which used to be called Office Web Apps Server) and as a result Excel Services is being replaced with Office Online Server.

Here is a summary of the main benefits brought to you by moving to Office Online Server and the latest and greatest version of Excel in your BI deployment. Many of these benefits are not limited to BI scenarios, but are valuable in other setups as well.

More Excel features—Additional features include the ability to search in Pivot Table filters, number formatting, ability to view and insert comments and the addition of Excel JS APIs.

Robust, unified deployment—You can deploy it with other Office Web apps. Use it for viewing, editing and BI.

Basic Excel BI capabilities with SharePoint Standard CAL—Use data model and/or access external data. Refresh and save your refreshed workbooks.

Evergreen service—Always stay up to date, get many of the same features and improvements as Office 365.

Here is a look at the architecture of the Microsoft BI Stack 2016 for on-premises:

Key facts

The following list summarizes key facts about our on-premises offering in Microsoft BI Stack 2016 release.

All Excel web functionality including BI, viewing and editing of workbooks is now under one roof. Capabilities that were previously provided by Excel Services are now provided by Excel Online in Office Online Server.

Office Online Server is now a prominent member of the MS BI Stack. It requires a machine of its own. Deploy Office Online Server with Excel Online and bind it to SharePoint Server for SharePoint BI features to work.

SharePoint Server 2016 performance and scalability are no longer impacted by Excel Services footprint. Instead, Excel Online is deployed and scaled alongside other Office web applications using an Office Online Server farm.

Workbooks created in previous versions of Excel desktop client are fully supported and can be published.

Working with a data model requires SSAS (in PowerPivot for SharePoint mode) but doesn’t require PowerPivot for Sharepoint add-in. The latter is available only with SharePoint eCAL.

If possible, we recommend upgrading the on-premises environment before upgrading desktop clients. This will allow new workbooks taking advantage of new features of Excel 2016 to be fully supported by the BI farm.

MS BI Stack 2016 on-premises should be upgraded bottom-up. To leverage advanced SharePoint BI features provided by its add-ons, on-premises MS BI Stack 2016 should be deployed in its entirety. Otherwise, if you only need the ability to access external data (e.g., use data model, connect to OLAP/Tabular DBs), it will be sufficient to upgrade your SSAS (in PowerPivot for SharePoint mode) and deploy the Office Online Server. SharePoint Server itself does not have to be upgraded in such a case.

Office Online Server is evergreen. Meaning, it is now possible to keep end-users on the latest and greatest functionality through frequent upgrade cadence. A lot of Office 365 improvements will now find their way to your on-premises environment.

SharePoint Server 2016 licensing also incurred changes. First, SharePoint Server 2016 no longer offers the Foundation SKU. It now comes only in Standard and Enterprise SKUs, with Standard CAL and Enterprise CAL licenses. Second, licensing requirements for some SharePoint Insights features have been relaxed. Namely, accessing external data, refreshing and working with a Model is now possible with all SharePoint SKUs, but advanced capabilities such as PowerPivot for SharePoint add-in, Reporting Services add-in, Excel Web Parts and ODC file support will still require SharePoint Enterprise CAL.

Key facts

The following list summarizes key facts about our SharePoint Server 2016 licensing changes:

Refresh, OLAP connectivity and Data Model interactivity are now supported in all SharePoint SKUs.

SQL licenses still apply, where necessary. (There is no change in this respect.)

With the new SharePoint 2016 release and Office Online Server, we’ve completed the move toward a unified architecture for viewing and editing Excel workbooks using Office Online Server. Moving to the new architecture provides users with access to the latest and greatest Excel features and adds new BI-specific features, such as search in PivotTable filters, and helps IT unify the deployment around one farm of Excel servers instead of two. In addition, we’ve simplified the licensing model, and you can expect Excel to be evergreen and keep getting new capabilities on a regular basis.

Please tell us what you think by commenting below.

—The Excel team
Click to expand...

Source: Updates for Excel Services and BI in SharePoint 2016 on-premises - Office Blogs

Brink · Sep 8, 2022

Power BI Search in SharePoint home, Office.com, Bing, and Windows 10

Power BI is the Magic Quadrant Leader among analytics and business intelligence platforms and over 200,000 customers around the world use Power BI and bring 40 petabytes of data into Power BI every month 1 and now, we’re building on that momentum with Power BI in Microsoft Search.

Microsoft Search transforms the way people in your organization find the info they need—no matter where you are in your cloud journey. Either integrated with Microsoft 365 or as a standalone solution, Microsoft Search is a secure, easily managed, enterprise search experience that works across all of your applications and services to deliver more relevant search results and increase productivity.

With Power BI search in Microsoft Search we’re making it easier to find Power BI artifacts such as reports and dashboards, by expanding the ability to search across these artifacts in your favorite productivity apps including , Office.com, Microsoft Bing, and the search box in .

Power BI search in Microsoft Bing

Power BI search in SharePoint

Power BI search expands the tenant-wide search scope through a built-in powerful search experience with Power BI content, to intelligently help search user to find the most work relevant information more productively.

Built-in experience: Seamless out-of-box search experience to easily and quickly find Power BI dashboard and report across your organization without switching back and forth between search portal and Power BI site.

Richer content: Modernized search experience to present Power BI data in the most useful way. Enrich Power BI search content beyond just hyperlinks to include more key information, such as type, owner.

Maximize access to information with data protection: Show the search result with relevant Power BI data that’s authenticated to you based on your workplace identity.

Unified search experience: Cohesive and coherent search experience to incorporate richer Power BI search content in bing.com, office.com, sharepoint.com. Search wherever you want to and get the consistent experience.

Can I disable Power BI search ?

Power BI search is enabled for your organization by default. Your organizations’ Power BI admin can disable Power BI search in the Power BI admin portal if desired. In the Power BI admin portal, navigate to Tenant settings and then disable the Use global search for Power BI. To learn more refer to Administering Power BI in the admin portal.

Power BI admin
Click to expand...

Source: https://techcommunity.microsoft.com/...m/ba-p/1999205

Paolo Mag · Sep 8, 2022

Power BI

Hello James,

This issue with using Power BI requires advanced technical assistance. For you to get the most appropriate resolution, we suggest that you post your concern in our
Power BI Community. From there, our team from Power BI who specializes with this software will assist you.

Let us know if you need further help with any Windows issue.

Windows 10: POWER BI TO UPDATE SHAREPOINT LIST WITH NO DUPLICATES?

POWER BI TO UPDATE SHAREPOINT LIST WITH NO DUPLICATES?

POWER BI TO UPDATE SHAREPOINT LIST WITH NO DUPLICATES?

POWER BI TO UPDATE SHAREPOINT LIST WITH NO DUPLICATES?

POWER BI TO UPDATE SHAREPOINT LIST WITH NO DUPLICATES? - Similar Threads - POWER UPDATE SHAREPOINT

Download Power BI

Download Power BI

bring a mysql database into sharepoint , sharepoint list ?

POWER BI TO UPDATE SHAREPOINT LIST WITH NO DUPLICATES?

Power BI Help

Power BI Help

Power BI Search in SharePoint home, Office.com, Bing, and Windows 10

Sign-in for Power BI

Updates for Excel Services and BI in SharePoint 2016 on-premises