Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
@sirarthur_ - Is this when you are trying to Export data on a visualization?
Hi Greg!
Yes, but that occurs too when i'm in the file and in the embedded version of this report.
@sirarthur_ , 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
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"}
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
29 | |
14 | |
11 | |
10 | |
9 |