Power Pivot

Question

Power Pivot

Rakib Ahmmed 1

I need a help, As we know Excel can load only 1,048,576 rows, but my power pivot table result need more than 2 millions of rows, that's why I don't load it in the general excel by power pivot, so I need to make the output into a CVS file. how can I do it....?

2 answers

Your answer

Answer 1

Lz._ 9,016

Hi @Rakib Ahmmed

It would be smart of you to revise the title of this thread so it better reflects your requirement (can help others who search this site - Thanks)

DAX Studio allows saving to CSV and does many other things...

Answer 2

Mohd Ansari 1

How can i show Total sales outside Power Pivot Graph

Lz._ 9,016 Reputation points

2021-03-13T16:01:15.67+00:00
Hi @Mohd Ansari

Your question doesn't seem to relate to the initial question (Pivot Table > 1,048,576 rows) raised in this case so please:

Create a new thread with a title reflecting what you need/expect to acheive

Provide more information (see min. below) than "How can i show Total sales outside Power Pivot Graph" otherwise nobody will be able to assist

What columns do you have in your Power Pivot table(s)?

Do you already have a 'Total sales' measure (that works)?

How do you want the chart to look like

...etc
Ideally upload a couple of pictures to clarify things

Share via

Power Pivot

2 answers

Your answer