topic Re: I cannot extract a report when the Matrix has a certain mensure in DAX Commands and Tips

I cannot extract a report when the Matrix has a certain mensure

Anonymous — Fri, 04 Sep 2020 19:05:08 GMT

Hi guys!

Hope y'all doing well.

Well, I have a Matrix with some data to do some drill down and when I use a certain Value that was direct imported from a DW I can extract that Matrix without no problem, but when I change for a mensure the extraction do not work.

This is the DAX I have made in that mensure:

TotalCost =

VAR table = SUMMARIZE(DimCustomer,DimCustomer[AccountNumber],DimCustomer[PartnerAccountNumber],"MarkupVal",MAX(Markup[Markup]),"Cost",[Total Cost])

RETURN

SUMX(table,
IF(ISBLANK([MarkupVal]),[Cost],
[Cost]*([MarkupVal]-1)+[Cost]))

Anyone else is having this problem?

I have collect the query of this extraction and the result in SQL Profile is that the query Begin and End as they should be, but in the end, the file won't extract.

Btw, this is the message thar is showed when I have this problem: "The file could not be created".

Thanks everyone.

Re: I cannot extract a report when the Matrix has a certain mensure

Greg_Deckler — Fri, 04 Sep 2020 19:29:14 GMT

Anonymous - Is this when you are trying to Export data on a visualization?

Re: I cannot extract a report when the Matrix has a certain mensure

Anonymous — Fri, 04 Sep 2020 19:38:02 GMT

Hi Greg!

Yes, but that occurs too when i'm in the file and in the embedded version of this report.

Re: I cannot extract a report when the Matrix has a certain mensure

amitchandak — Sat, 05 Sep 2020 04:54:48 GMT

Anonymous , check if power bi Log files can give a better idea

https://dbakevlar.com/2018/07/power-bi-101-log-files-and-tracing/

https://community.powerbi.com/t5/Report-Server/Power-BI-Log-Files/td-p/368703

Else log an issue with log /trace of error

https://community.powerbi.com/t5/Issues/idb-p/Issues

Re: I cannot extract a report when the Matrix has a certain mensure

Anonymous — Tue, 08 Sep 2020 14:12:17 GMT

Hi!

I have done the debug and I have analyse the .txt and the results are too long to post here, but I have found these 5 rows that have a long duration of time, but don't find any clue to solve the problem.

These are the five rows I mentioned before:

Trace Information: 24579 : {"Start":"2020-09-08T11:24:22.9068380Z","Action":"PBI.DS.ExecuteReader","isError":"True","sessionId":"2712f753-a709-4864-aa41-b6133dd57ff5","deviceId":"cbcc7224","userId":"6cbb65ef-a838-452f-818c-ee7ccfa03128","isInternal":"False","authenticatedUserId":"98d58721-6dfd-4012-8c12-1244f123e496","ProductVersion":"2.84.981.0 (20.08)","ActivityId":"ae1eeccc-6e46-4a52-9fef-7746aad59e9d","Process":"PBIDesktop","Pid":2472,"Tid":29,"Duration":"01:00:01.0190508"}

DataMashup.Trace Information: 24579 : {"Start":"2020-09-08T11:24:22.9068380Z","Action":"PBI.DS.QueryExecution","EventTarget":"LogsOnly","isError":"True","sessionId":"2712f753-a709-4864-aa41-b6133dd57ff5","deviceId":"cbcc7224","userId":"6cbb65ef-a838-452f-818c-ee7ccfa03128","isInternal":"False","authenticatedUserId":"98d58721-6dfd-4012-8c12-1244f123e496","ProductVersion":"2.84.981.0 (20.08)","ActivityId":"14dd9988-da22-4f89-a5e3-54363d0f315e","Process":"PBIDesktop","Pid":2472,"Tid":29,"Duration":"01:00:01.0195561"}

DataMashup.Trace Information: 24579 : {"Start":"2020-09-08T11:24:22.9068380Z","Action":"PBI.DS.DataShapeProcessing","EventTarget":"LogsOnly","isError":"True","sessionId":"2712f753-a709-4864-aa41-b6133dd57ff5","deviceId":"cbcc7224","userId":"6cbb65ef-a838-452f-818c-ee7ccfa03128","isInternal":"False","authenticatedUserId":"98d58721-6dfd-4012-8c12-1244f123e496","ProductVersion":"2.84.981.0 (20.08)","ActivityId":"c8816cb7-0df1-4f5c-b36d-e4b254026d7d","Process":"PBIDesktop","Pid":2472,"Tid":29,"Duration":"01:00:01.0270812"}

DataMashup.Trace Information: 24579 : {"Start":"2020-09-08T11:24:22.8988375Z","Action":"PBI.DS.ExecuteSemanticQuery","sessionId":"2712f753-a709-4864-aa41-b6133dd57ff5","deviceId":"cbcc7224","userId":"6cbb65ef-a838-452f-818c-ee7ccfa03128","isInternal":"False","authenticatedUserId":"98d58721-6dfd-4012-8c12-1244f123e496","ProductVersion":"2.84.981.0 (20.08)","ActivityId":"cb4c6592-942f-4fcb-a044-7b8676ed51ef","Process":"PBIDesktop","Pid":2472,"Tid":29,"Duration":"01:00:01.0488528"}

DataMashup.Trace Warning: 24579 : {"Start":"2020-09-08T11:24:22.7480000Z","Action":"PBI.EX.ExportVisualData","parentId":"251ffd5f-5b58-c1bd-a102-5f148b3f3d1e","isError":"true","errorSource":"PowerBI","errorCode":"2","activityName":"PBI.Dashboard.RootSession","activityId":"251ffd5f-5b58-c1bd-a102-5f148b3f3d1e","visualType":"pivotTable","source":"Report","isPartialResult":"false","dest":"0","isPremiumUser":"false","isDrillToDetailsMode":"false","dataType":"0","end":"2020-09-08T12:24:24.032Z","duration":"1min+","buildType":"release","minervaBuild":"11.0.0827.024553","sessionId":"2712f753-a709-4864-aa41-b6133dd57ff5","deviceId":"cbcc7224","userId":"6cbb65ef-a838-452f-818c-ee7ccfa03128","isInternal":"False","authenticatedUserId":"98d58721-6dfd-4012-8c12-1244f123e496","ProductVersion":"2.84.981.0 (20.08)","ActivityId":"9dd483ff-8239-4930-a7cf-8e5443f05f18","Process":"PBIDesktop","Pid":2472,"Tid":20,"Duration":"01:00:02.5616685"}