I'm sure someone has provided all Hugh Taylor's results but I just wanted to know if I could do it in Power Query.
Alas, PQ is not up to scraping the web parts, so I used Power BI
After exporting the data as CSV file, I was able to use PQ to import the data into Excel.
Unfortunately I'm not able to upload the Power BI .pbix file but see attached Excel file.
If you wanted to use it you will see you can put the File Location (on your computer) & File Name (if you wish to rename the file).
Note: the PQ will not work if you put it in a OneDrive location (that requires a different PQ connector)
Power Query - Hugh Taylor Results
- paspuggie48
- Posts: 665
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
You do not have the required permissions to view the files attached to this post.
Last edited by paspuggie48 on Fri Oct 20, 2023 7:30 am, edited 1 time in total.
- paspuggie48
- Posts: 665
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Some people get an error when running queries.
This is usually down to their privacy settings.
To resolve this go to the Data Tab > Get Data > Query Options > Privacy
Ensure 'Always ignore Privacy level settings' is selected.
This is usually down to their privacy settings.
To resolve this go to the Data Tab > Get Data > Query Options > Privacy
Ensure 'Always ignore Privacy level settings' is selected.
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 665
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Oops, my apologies.
I just realised I cannot upload the CSV file either. Unless Admin can authorise?
If not, you are stuck with just the Excel file, as is
I just realised I cannot upload the CSV file either. Unless Admin can authorise?
If not, you are stuck with just the Excel file, as is