March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
We have PBIX file (3MB only) linked to Excel file in Same Location. When Refreshing data/change month its taking much time to refreshing Visualizations. Published also taking much time to refresh data
@Hemasekhar wrote:
We have PBIX file (3MB only) linked to Excel file in Same Location. When Refreshing data/change month its taking much time to refreshing Visualizations. Published also taking much time to refresh data
Could you try to disable those highlighted options? If the slowness still persists, could you share the pbix file and excel file?
Thank you Eric_Zhang for your prompt response.
As you suggested disabled those highlighted options and still slow. Could you please tell me how can I share the pbix file and excel file?
Some observations: In Task Manager 'Microsoft Mashup Evaluation Container' is showing multiple times.
Eric_Zhang,
As you suggested I have copied two files (pbix, excel) into Google drive and Shared links to you. Could you please look into refreshing issue.
Thanks & Regards,
Hemasekhar
The original pbix doesn't takes too much time to refresh in my PC.
Could you try to create a new BaseQuery as
let Source = Table.Buffer(Excel.Workbook(File.Contents("E:\SourceData.xlsx"), null, true)) in Source
And in other queries, reference this BaseQuery as source, instead of retrive data from the excel?
let Source = BaseQuery, #"CPI Metrics Data_Sheet" = Source{[Item="CPI Metrics Data",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(#"CPI Metrics Data_Sheet", [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Application Name", type text}, {"Release Month", type text}, {"Release Year", Int64.Type}, {"Release", type text}, {"Number of Valid Pre-UAT Defects-P1&P2 (UST)", Int64.Type}, {"Number of Valid Pre-UAT Defects-(Other than P1 & P2) (UST)", Int64.Type}, {"Number of Valid Pre-UAT Defects#(lf)Defect P1 &P2 #(lf)(Non UST)", Int64.Type}, {"Number of Valid Pre-UAT Defects #(lf)(Other than P1 & P2) (Non UST)", Int64.Type}, {"Number of Valid UAT #(lf)Defect- #(lf)(P1 & P2) (Non UST)", Int64.Type}, {"Number of Valid UAT Defect #(lf)(Other than P1 & P2) #(lf)(Non UST)", Int64.Type}, {"Number of Valid Production Defects (P1 &P2)", Int64.Type}, {"Number of Valid Production Defects (Other than P1 & P2) ", Int64.Type}, {"Total Valid Defects Raised by UST", Int64.Type}, {"Total Defects Raised by UST", Int64.Type}, {"No of Delivery Commitments met on Time", Int64.Type}, {"#(lf)No of Delivery Commitments Not met on Time", Int64.Type}, {"Simple", Int64.Type}, {"Avg", Int64.Type}, {"High", Int64.Type}, {"V.High", Int64.Type}, {"Simple4", type number}, {"Avg5", type number}, {"High6", type number}, {"V.High7", type number}, {"Simple8", Int64.Type}, {"Avg9", Int64.Type}, {"High10", Int64.Type}, {"V.High11", Int64.Type}, {"Simple12", type number}, {"Avg13", type number}, {"High14", type number}, {"V.High15", type number}, {"Simple16", Int64.Type}, {"Avg17", Int64.Type}, {"High18", Int64.Type}, {"V.High19", Int64.Type}, {"Simple20", type number}, {"Avg21", type number}, {"High22", type number}, {"V.High23", Int64.Type}, {"Total #Applicable Regression Test Cases", Int64.Type}, {"Total # Regression Test Cases Available", Int64.Type}, {"Total # Regression Test Cases Executed", Int64.Type}, {" Total # Automatable Test Cases", Int64.Type}, {"Total # Test Cases Automated ", Int64.Type}, {"Total # Automation Test Cases Executed ", Int64.Type}, {" Total # Automatable Test Cases planned for the month", Int64.Type}, {"Total # Test Case Automated for the month", Int64.Type}, {"Month No", Int64.Type}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Release", "Release"}}) in #"Renamed Columns"
Also try to disable the option "Autodetect new relationship after data is loaded" in the snapshot in my previous reply.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
99 | |
89 | |
72 | |
62 |
User | Count |
---|---|
140 | |
121 | |
106 | |
98 | |
94 |