Hi,
I'd like to upload an xls/csv file I receive via url on a regular basis from Meta Ads server, directly into my Power Bi dashboard. I've been trying several ideas for a few weeks now but I've never totally bridged the thing with it :
- tried downloading the file in my Onedrive account but seems like the url couldn't be split from the rest of the message body
- tried to write the link into an excel file connected to my power bi dashboard but it also didn't work for the same reasons + the url is encrypted with SafeLinks
Could you help me find the definite solution without Premium components ?
Many thanks
Antonin