Forum Discussion
Files combining live export with pivot tables corrupting
Hi
Thanks for this. Unfortunately I don't have access to the data warehouse, so can't use powerquery before exporting.
When this happens the workbook corrupts on opening, presumably because a piece of data changed overnight (we have daily refresh, pulling data from multiple forecasting systems open to 200+users). Is there a way I can use powerquery within the spreadsheet (rather than pre-import) to help with this?
Hi ahah95nY
Yes, you can use Power Query directly within your spreadsheet to help with your data tasks! Here’s how you can do it:
- Open Excel and go to the Data tab.
- Click on Get Data to see a variety of data sources you can connect to, such as files, databases, and online services.
- Select the data source you want to connect to and follow the prompts to load the data into Power Query.
- Once the data is loaded, you can use the Power Query Editor to transform and clean your data. This includes filtering rows, removing columns, merging tables, and more.
- After making your transformations, click Close & Load to load the data back into your Excel worksheet.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi there
Thanks for this! Unfortunately the dataset isn't available as a datasource within PowerQuery using this method, presumably because I don't have access to the underlying data lake.
It sounds like our only option is to either 1) convince the IT team (who do have access) to resolve this, or 2) negotiate access ourselves.
- Open Excel and go to the Data tab.