Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mikelee1701
Helper III
Helper III

Getting data from a website list with only certain file names

HI All,

 

I have a website that is simply listing files like .csv.   But I only want the ones that are *.byday.csv

How can I pull in only the files that meet my criteria?  Like FY16_byday.csv, FY17_byday.csv, FY18_byday.csv... and so on?


Screenshot_091720_041233_PM.jpg

 

I tried this:

Screenshot_091720_041952_PM.jpg

 

Thanks in Advanced,

Mike

 

2 REPLIES 2
Icey
Community Support
Community Support

Hi @mikelee1701 ,

 

Please refer to these posts:

Data Download from Website and connection with Power BI;

Combining Multiple 'Web' Data Sources.

invoke.PNG

 

This needs to manually filter the required files and manually enter part of the file name.

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HI,

Thanks, but I'm not sure that's what i'm trying to accomplished...

I want to pull in all the *.CSV files. that will continuesly get pushed to that website when it become available.

It seems with those examples, I'm still defining a range of specific files which means I'll need to manage any new files coming in.

 

Correct me if i'm wrong.

 

Thanks,

Mike

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.