Home Excel

BI and Data Analysis

31 Conversations

Latest Activity

Custom List Message Item

I am working in Power BI Desktop and I need to be able to access files that are stored on a network share. I'd like to be able to just click on the link and get the file.
I have 2 columns named Folder_Location(UNC path - \\Server\Folder\) and FileName.

... Read More
6 Replies

Hi Guy,


For my knowledge that doesn't work so far. Power BI Desktop (as well as G&T with Power Pivot, same engine) converts the text into the hyperlink if only your text

... Read More

Is PowerPivot for Excel 2013 32 bit compatible with SQL Server 2014 SP1 Enterprise 64 bit ?

3 Replies
I have some problem to connect PowerPivot for Excel 2013 32 bit and SQL Server 2014 SP1 Enterprise 64 bit, and I wasn't sure if this configuration is OK, because I find o... Read More
Hi Jean-Claude, in what way do you need it to be compatible?

This is only since the most recent Power Query update. I've attached a screenshot of what Power Query displays as well as an attachment of the raw data file being consolidated. Please advise.

13 Replies

Just a follow up to my earlier response.


It looks like the text file is fixed width.  


I pulled it in using the following steps (See attached image and file)




Fixed Width Text File.PNG

Note: I di

... Read More

Hi @Cory Barnes,


I get the same issue as you whether I use the older version of Power Query or the new one.


Can you send a screenshot of the original M code from the Powe

... Read More

Using Microsoft EXCEL. I have a question regarding the ANOVA, two-factor  with replication. I have my data set up such that I have three columns with differnent sample types (labeled above) and 8 rows per sample for two sample groups (labeled on left) and

... Read More
0 Reply

Hello Community. I have a quick question to ask the community. I have a data set (attached below) I'm trying to answer a few questions. i need to find a way to make a table that counts the number of times each player_name and team_name had an offensive re

... Read More
1 Reply



Perhaps easiest way is to use Get&Transform.


If i understood your logic correctly. Name your first column as ID (in A1), when generate the query on your data (stay on

... Read More

Is there an easy way, function etc, that will allow me to include as part of my report name, the current visible scenario name. The issue is I run multiple scenarions and have to manually change the report title every time I run a scenario? 


Your help wil

... Read More
3 Replies

Hi James


Are you using Scenario Manager?


In which case include a cell reference for your heading for each scenarion.


e.g. in the screen shot I have added a reference to c

... Read More
It's not in Power Pivot as yet, hopefully soon. Ashvini Sharma Excel
I haven't checked, but it may be in the latest update for Excel. IT's the same engine as the other two products, just a couple of months behind.


On the office 365 plans page a lot of screen space is taken up highlighting (IMHO) fairly low priorty features for small and medium businesses.


The fact that none of these plans contains Power Pivot is much more significant and should be flagged as such.

... Read More
5 Replies

Thank you for letting us know there is some confusion about how to get Power Pivot, and which versions of Office have it. We've put together a help article at https://support.office.com/article/aa64e217-4b6e-410b-8337-20b87e1c2a4b

... Read More
Best Response

They don't contain some other features as well. More exact comparing is here https://technet.microsoft.com/en-us/library/office-applications-service-description.aspx

I gue

... Read More
I am new to using excel and I cannot figure out how to sort this data and I don't really know how to say this. I have 3 column that need sorting from another file. Two at empty and one is full of client names. The other also has client names, but fewer, a... Read More
1 Reply

Hi @Dagnija Zitmane


Could you send some screen shots or attach the file to help us understand what you are trying to do please.



Read More



I am having great difficulty in figuring out what i am doing wrong. I have to create a Histograms based on the last 60 days of high temperatures for my Stats class. While i understand how to generate the Histogram... it does not generate correctly?

... Read More
2 Replies
Kindly send the sample file if you don't mind and state the Excel version you are using as well.

Hi Megan, can you attach an example file, or if not then some screen shots?

I am used to seeing Analysis Toolpak in the top right corner of the Data tab in Excel.  It has disappeared. It is loaded according to the Options section in File.  How can I get it back?

4 Replies

Hi Steve,

Am assuming you are using Excel 2016.

Anyway, the ATP (Analysis Tool Pack) can be enabled by the following steps:

File>Options>Add-ins........."Manage: Excel Add-i

... Read More

I reappeared today.  I do not understand.

I also have the same problem

am used to seeing Analysis Toolpak in the top right corner of the Data tab in Excel.  It has disappeared. It is loaded according to the Options section in File.  How can I get it back?

0 Reply

Can someone explain the computational formula Excel uses for the two sample mean t-test for samples with unequal variances.  I've attached all I can find from Excel.  In particular what is delta sub o, m and n variables?? Thanks ...Andy


Read More
0 Reply

That's not the question, just to share my experience if it'll be useful for someone.

I had Excel data model published on Power BI with two queries (actually much more, but these two are in questions) -

Q1 which pick-ups data from on-premises SQL server, and

... Read More
0 Reply

hi everyone,

i use Excel 2016 and want to connect to a SharePoint list in the cloud, with oData connection.

It works well for some of my lists, but for others lists, i have a error message.

"the following system occured. The type doesn't correspond".

From oth

... Read More
0 Reply