Get xlsx file from website
Hi guys, I am trying to find solution how can i link external data source to PBI . In my case my data is .xlsx file located on web page, and i have several of them. So basically i need get excel files from web pulled in to PBI and have it automated, because this files refresh each day. i have this (did use custom name to protect source web page - name.something.com/admin file1_2023-01.xlsx file1_2023-02.xlsx file1_2023-03.xlsx file1_2023-04.xlsx file1_2023-05.xlsx
Easy Way to Delete Columns Not in Use
Hello All, I have an Azure SQL database that I pull into my reports. It's quite large so I like to go through and delete columns not getting used in a report to help speed up the response and refresh times. I have been going through and doing this manually. My question, is there a way to do this easier or for the system to somehow tell me what columns arent being accessd so I can then delete them? Thank you
