The future for me

I was reading through the email from The Databse Weekly and I saw an article from Paul Randal with regards to Paul being your mentor. This really got me thinking and where is my future within Business Intelligence (BI).

I really love what I do. I get great satisfaction and enjoyment when I can tell people a story about their data. Or show them insights into their data for the first time.

I find it easy to grasp new concepts and get it all working. I work entirely within the Microsoft BI toolset.

With the new Office 365 and Power BI offerings there is a whole new world to get my head around. It really excites me.

I have also started working for a BI consulting company and it equally exciting times here. They are looking to expand and really get into the Microsoft BI space. That’s where I come into the picture.

I feel that I am at the right place at the right time. In terms of using my existing knowledge within the Microsoft space, as well as enabling the consultancy to grow from strength to strength going forward.

This is where I feel that the being mentored by Paul Randal could get me onto the next level, which is where I want to go and where I will eventually get to. Being mentored by someone as knowledgeable and experienced means I can get there a little quicker!

So where do I see myself in the future?

I see myself learning and going to that next level. Enabling businesses to gain insights to their data faster and quicker than ever. As well as driving the BI consultancy to become the go to consultancy for Microsoft BI.

Error: An Item with the same key has been already added – Unable to load the tables in the Power Pivot Window

NOTE: First thing to do is to make a copy of your Excel Workbook, before making any changes to your Power Query Source. If you do NOT, and change your Power Query source, your Power Pivot Model could become unusable!

1.      I had an issue where if I changed the Power Query source from a CSV after I made changes to my data in my Data Model, once saving the Excel workbook, and then going back in I would get the following error:

a.      clip_image002

2.      So what I did to try and fix it was to do the following

a.      Get the data into Power Query correctly, so that it was working as expected.

3.      Then went into the Loading of the Power Query data to the Data Model.

a.      Right click and selected Load To:

                                                    i.     clip_image004

b.      Then un ticked both options

                                                    i.     clip_image006

                                                   ii.     You will then get prompted with the following below:

                                                  iii.     clip_image008

                                                 iv.     Click Continue

c.      It will then come back saying that the Load is Disabled:

                                                    i.     clip_image010

d.      Now go back and again Right click and selected Load To:

                                                    i.     clip_image004

e.      This time select the following:

                                                    i.     clip_image012

f.       Now this will load your data into the Data Model.

4.      Next you can open Power Pivot

5.      What I did next was to rename my Sheet which I am hoping will break the association with the old sheet that was in the Data Model.

a.      Renamed it from:

                                                    i.      clip_image014

b.      To:

                                                    i.      clip_image016

6.      I then went and saved my Excel Workbook, closed it. Opened it again and went into Power Pivot.

a.      So far so good.

7.      I then went back and renamed the sheet in the Power Pivot Data model, back to the Original Name

8.      And I got the same error:

a.      clip_image017

9.      So currently the only way I can see to get this to work, is to keep my new Name.

10.   Which means having to re-do or add my fields to the existing reports.

11.   NOTE: Reading further down the error, it talks about Synonyms, so my educated guess is that it has something to do with the Synonym data, not allowing changes to be made within the Data Model.

Power QUery – Creating

Hi there, it has been quite a while since I have posted anything. After moving country and getting my first job. I have subsequently moved to my second job which is going really well.

So I have started working on all the new BI Features that Microsoft has been offering and below is something that I needed to do, is from our Date Table, I had a requirement to create the following Month-Year (Jan-15). This was so that we could then join to my source data.

I did the following steps below in Power Query

1.       I went into Power Query and clicked on the Add Custom Column

a.       clip_image002

2.       And then I put in the following in order to get my Month-Year

Date.ToText([Date], “MMM”) &”-“&Text.Range(Number.ToText([Year]),2,2)

a.       clip_image004

3.       I then clicked Ok and got the following as shown below

a.       clip_image006