question

RakibAhmmed-5498 avatar image
0 Votes"
RakibAhmmed-5498 asked ·

Power Pivot

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....?

power-query-dataflows
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Lz-3068 avatar image
0 Votes"
Lz-3068 answered ·

Hi @RakibAhmmed-5498

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...


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MohdAnsari-7872 avatar image
0 Votes"
MohdAnsari-7872 answered ·

How can i show Total sales outside Power Pivot Graph

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MohdAnsari-7872

Your question doesn't seem to relate to the initial question (Pivot Table > 1,048,576 rows) raised in this case so please:
1. Create a new thread with a title reflecting what you need/expect to acheive
2. 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

0 Votes 0 ·