Windows 10: Excel 2016 Issue - I am having a new problem bug? Connecting to a Text file in PowerPivot -...

RobC_expd · Jun 10, 2020

Hoping someone knows if something changed this last month. Each Month I create a PowerPivot that connects to a CSV file that is Tab delimited. This month, I tried to Connect to the Data source in the PowerPivot Manage, and found that it would not Delimit on the columns as it would in the past. I then tried to Connect to one of the older CSV files which used to work, and am having the same issue. What happens, is that it seems to remove the spacing in the column headers when it initially imports the CSV into the "Connect to a Data Source" wizard. This never occurred in the past. Any suggestions?

Sample data in CSV format:

COMPANY GCI_TYPE REVENUE_CLIENT GLBRANCH PRODUCT STATUS COMMISSIONGL_ACCOUNT_TYPE USD_AMOUNT LOCAL_CURRENCY LOC_AMOUNT

AE 4055 130 OXP 1 Y 4169.97 AED 624.32

AE 4061 130 AXP 1 Y 4-7.22 AED -26.52

AE 4061 130 AXP 1 Y 4139.23 AED 511.4

AE 4061 130 AXP 1 Y 4-115.06 AED -422.63

AE 4061 130 AXP 1 Y 4-1.05 AED -3.84

AE 4061 130 AXP 1 Y 4-3.03 AED -11.12

AE 4061 130 AXP 1 Y 4-4.8 AED -17.63

AE 4061 130 AXP 1 Y 4-266.51 AED -978.93

AE 4061 130 AXP 1 Y 4160.37 AED 589.07

AE 4061 130 AXP 1 Y 4-352.62 AED -1295.24

AE 4061 130 AXP 1 Y 477.39 AED 284.25

AE 4061 130 AXP 1 Y 4-173.34 AED -636.72

:)

Dennis45a · Jun 10, 2020

Powerpivot 2010 crashes on Windows 10 Upgrade

After upgrading to Windows 10 from Windows 8.1, I no longer am able to use PowerPivot in Excel 2010. PowerPivot will not enable when checking the com-addins on the Options menu in Excel. I have tried to uninstall and reinstall PowerPivot with no success.
Absolutely no problems with PowerPivot while running in Windows 8.1. Any help will be greatly appreciated.

Brink · Jun 10, 2020

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 · Jun 10, 2020

April 2017 updates for Get & Transform in Excel 2016 and Power Query

Excel 2016 includes a powerful set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.Today, we are pleased to announce five new data transformation and connectivity features that have been requested by many customers.

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

These updates include the following new or improved data connectivity and transformation features:

Support for the same file extensions in Text and CSV connectors.

ODBC and OLE DB connectors—support for Select Related Tables.

Enhanced Folder connector—support for “Combine” from the Data Preview dialog.

New Change Type Using Locale option in Column Type drop-down menu inside Query Editor.

New Insert Step After option in Steps pane inside Query Editor.

Support for the same file extensions in Text and CSV connectors

With this update, we revised the list of supported file extensions in From Text and From CSV connectors. Now, you can browse and select any text (*.txt), comma-separated value (*.csv) or formatted text space delimited (*.prn) file as the first step of the import flow for both connectors. Alternatively, you can switch to the All files (*.*) filter option and select to import data from any other unlisted file.

ODBC and OLE DB connectors—support for Select Related Tables

When using the ODBC and OLE DB connectors, we enabled the Select Related Tables button in the Navigator dialog. This option—already available for other relational data sources—allows users to easily select tables that are directly related to the set of already selected tables in the Navigator dialog.

Enhanced Folder connector—support for Combine Binaries from the Data Preview dialog

In the January 2017 update, we shipped a set of enhancements to the Combine Binaries experience. You can learn more about those enhancements in this article.

This month, we made it easier for customers to access the Combine Binaries feature by allowing them to combine multiple files directly from the folder Data Preview dialog within the Get Data flow, without having to go into the Query Editor.

Note that exposed multiple options (Combine and Combine & Load) allow customers to further refine their data before loading it into the worksheet or Data Model.

New Change Type Using Locale option in Column Type drop-down menu inside Query Editor

In the Query Editor, it is possible to see and modify column types by using the Column Type drop-down menu in the preview area.

With this release, we added the Change Type Using Locale option to this drop-down menu (previously available by right-clicking the column header and then selecting Change Type > Using Locale). This option allows you to specify the desired column type and locale to use for the conversion, which affects how text values are recognized and converted to other data types, such as dates, numbers, etc.

New Insert Step After option in the Steps pane inside Query Editor

With this update, we added a new context menu option in the Query Editor window to easily insert new steps in existing queries. The Insert Step After option lets users insert a new custom step right after the currently selected step, which can be the final step or any previous step within the query.

Learn more

Learn more about what’s new in Excel 2016.

Join our Excel community on Facebook and Twitter, and collaborate with others on Get & Transform Data at our new Tech Community forum.

Send us your ideas for other improvements on our Excel UserVoice page.

—The Excel team
Click to expand...

Source: April 2017 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs

Windows 10: Excel 2016 Issue - I am having a new problem bug? Connecting to a Text file in PowerPivot -...

Excel 2016 Issue - I am having a new problem bug? Connecting to a Text file in PowerPivot -...

Excel 2016 Issue - I am having a new problem bug? Connecting to a Text file in PowerPivot -...

Excel 2016 Issue - I am having a new problem bug? Connecting to a Text file in PowerPivot -...

Excel 2016 Issue - I am having a new problem bug? Connecting to a Text file in PowerPivot -... - Similar Threads - Excel 2016 Issue

I am having a problem on file explorer

I am having a problem on file explorer

I am having an issue with text scrolling in a number of applications.

I am having an issue with text scrolling in a number of applications.

Excel 2016

MS excel 2016 issue

Excel 2016

Excel file association shows EXCEL 2016 even though have Office19

Excel 2016