Forum

Hi Jennifer, The queries that are connection only don't make much difference to your file size at all since the data isn't getting loaded anywhere....

Hi Tania, The formula has too many parentheses, but that won't be causing the problem. Here's the same formula without the extra parentheses: =I...

Hi John, Welcome to our forum! Presumably the source file name is in a column. If so, you can simply use Replace to remove the .xlsx and then fo...

Hi Aye, You can use the OData link to connect Power BI to Xero. I'm not sure if the API will allow you to generate the trial balance at date int...

Hi Eileen, Power query isn't the right place to do a calculation like this. If you're using Power BI then you need to write measures that use th...

Hi Eileen, Your data is in the wrong format for a PivotTable. You shouldn't have a separate column for each month. You should have a column that co...

Hi Chris, Another option is to reference the PivotTable with formulas to recreate the source data where you can apply the number format you want. Y...

Hi Steven, Not sure why you aren't using Power Query to import the data. VBA is the old way to automate the gathering and cleaning of data. Mynd...

Hi Richard, Power BI doesn't allow you to input data and it uses the same Power Query tool as Excel, so this won't solve the problem, unfortunately...

Hi Chris, Thanks for sharing your file. If you want the chart to show every data point at the time level of detail, then the best you can do is nes...

Hi Vishnu, Please upload your file again. This time be sure to click the 'Start Upload' button and wait for the grey check mark beside the file siz...

Hi Fernanda, Please supply your file or a sample file so I can see what you mean. Mynda

Hi Doug, Hmmm, one option is to use formulas to automatically bring in the fields into the other tables, but formulas are risky as they're easily b...

Hi Sharon, Welcome to our forum! You can use Power Query inside of Excel or Power BI to clean this data. See Query 1 in the file attached. I...

Hi Richard, You can't have the workers enter data into the resultant query table. Power Query can only display data in a table that it gets from so...