March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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"}
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
26 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
40 | |
27 | |
27 | |
21 | |
20 |