Export data from a power BI report to another report/excel

[Arkhos94]

One collegue created a power BI report. I need the data from this report to integrate them in one of my own report and to integrate them in excel to perform some analysis.

What I tried : my collegue created a table with the data I need so I can export the table to excel

Problem : if I try to show all the data into the table I get a message saying the visual has exceeded the available resources with detail saying "You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available Memory."

If I could show everything, the table would be 400k lines long and with 17 column.

By using some filters I manage to extract a part of it (roughly 70 k lines out of the 400k) but cuting the 400k of data into small pieces to export is hardly a viable solution. Is there a way for me to export to excel all my 400 k lines of data ?

If not, would there be another way to get the datas ?

A few ideas I got to go around the problem but which end up in dead end :

1. my collegue could allow me to access his report's dataset. This way I could export the report in PBIX. From there, is there a way to export the data to a CSV/XLSX/anything else I can import to my own report ?
2. my collegue could allow me to access his report's dataset. From there, is there a way to connect my own report to the dataset (my report has already its own dataset with 15-20 tables so I guess the answer is no but I be missing something)
3. accessing the same raw data has he does for his power BI => forbidden by company policy 

[Arkhos94]

Hello @PaulDBrown and thanks for your help

I'm trying to negociate access to the source but right now it's forbidden due to my company policies. Can you think of any other way ?

[PaulDBrown]

@Arkhos94 

If you have acces to the source, copy the M-Code from the relevant queries and paste this code into a blank query in your dataset

[Arkhos94]

hello @amitchandak and thanks for your help

I read both links. 

There is no complicated formula in the report I'm trying to show? It basically show the raw data but with some filters so I cannot see what company policy forbid me to see. So I don't think the problem come from DAX

So if I understand your links correctly, the issue is the amount of data which is too much for the amount of data the table wants to show (400k lines/17 columns), am I right ?

If so, is there a way to go around this ? By accessing directly the report dataset for example

[amitchandak]

@Arkhos94 , refer these, if they can help

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=6cd37af6-...

https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/