FOR SALES ANALYSIS MONTH ON MONTH PIVOTS WITH DATA MODEL YES - WAS BUILT AS POWER PIVOT
NOW IN SALES TABLE I AM TRYING TO ADD NEXT MONTH DATA AND EXPECTING REFRESH ALL WILL AUTOMATICALLY REVISED POWER PIVOTS HOWEVER I AM FACING ERROR AS
"we couldn't get data from data model
the attributes relationship with attributes=month(month index) does not exist in collection"
PL GUIDE AS WHERE I HAVE MISSED AND NEED TO TAKE CARE
I HAVE MADE ONE CALENDER TABLE TO MATCH EVERYDATE AND MONTH AND QTR RELETED
AND ONE FACT TABLE OF MY SALES INVOICES LINKED ON INOICE DATE OF INVOICE DATEBLE WITH DATE IN DATE IN CALENDER TABLE
THANKS FOR YOUR TIME
@vipul-jhaveri You need to share your file. Otherwise it's difficult to help. Though, remove any private and confidential information before doing so.
THANKS FOR QUICK REPONSE
DATA SET IS HUGE AND VERY BULKY , SO IF POSSIBLE CAN YOU SUGGEST FOR
SIMPLY ADDING DATA TO SALES TABLE WITH COPY PASTE OF NEW MONTH SALES RECORDS AND EXTENDING FACT TABLE AND THEN CLICK IN PIOVTS FOR "REFRESH ALL" IS NORMALLY WORKABLE IN DATA MODEL SET UP OR NOT , I WILL ALSO TRY TO GET FEW SAMPLE RECORDS AND SHARE FILE AS YOU ASKED FOR
First I would like to suggest that you switch off CAPS-LOCK when you writes questions/comments like these. It’s more pleasant to read regular texts 🙂
I assume the data set landed in the DM via a Power Query (PQ) connection. As far as I know you can’t just copy data and paste it directly into an existing DM table. You need to go through PQ again or paste it in a new table that you then append to the existing (larger) one. But I don’t think that's a viable solution.
Thanks a Lot and aceept my apologoes for all caps, I will take care
Your valuable guidance will help me to avoid simply copy paste but route through PQ, i will try.
This Power Piovt made was simply based on , prime pivot creation with data model ticked yes while building power pivot, so PQ was not used for intital built up but now next month , data need to be added and copy paste in sales table was throwinig out error as seems not permitted as direct udpates
Further, to share this pivot (actual-1) , i also tried to slice down sales table to share with few records (sample-1) however , i am unable to revise power pivots with simple refresh all as conncetions are linked to old table so unable ,so far, to make small sample file to share
Thanks a lot for extending your quick and valuable advise
