Forum Discussion
Files combining live export with pivot tables corrupting
We have a few files that produce reports using a combination of live exports from PowerBI and pivot tables built on top of the export data. We would prefer to build these reports in PowerBI, but our ...
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.