DataFormat.Error: The input URL is invalid. Please provide a URL to the file path on SharePoint up t

[jeongkim]

There are 2 folders as above and all files stored in same format and columns. 

I created dataset for Current Weekly Data first and as soon as I duplicate it for Previous Backup Data,

keep getting error and cannot create custom column for tables. 

Current Weekly Data is getting Custom column for Table well.

Previous Backup Data case error message: (but it's weirdly random as sometimes it works)

I run this code for Current Weekly Data

and duplicate the dataset and rename the folder path for Previous Backup Data.

[jeongkim]

I found it has error if I put special character in file name when get data. 

without '#' > no error

with '#' > error

Is this bug? 

[123abc · Accepted solution]

It sounds like you’re encountering an issue with special characters in file names when using Power BI Power Query. This isn’t exactly a bug, but rather a known limitation. Special characters like # can cause errors because they are often used in URLs and can interfere wit...12.

To avoid this issue, you can try the following solutions:

1. Rename the File: Remove or replace the # character in the file name.
2. Use Encoding: Ensure the file path is correctly encoded in your query.
3. Escape the Character: In some cases, you might need to escape the special character in your query.

If renaming the file isn’t feasible, you might need to adjust your Power Query steps to handle the special character properly. For example, you can use double quotes around the file name or specific encoding settings12.

Would you like more detailed steps on how to implement these solutions?

please follow below links .. may is solve your issue:

(1) Solved: Special Character in Column Name - Microsoft Fabric Community

Solved: Combine File - Special Character Filename Errors - Microsoft Fabric Community

Solved: Importing special characters in a csv file into Po... - Microsoft Fabric Community

Solved: I see the special characters in the column values... - Microsoft Fabric Community

Solved: Power Query - Replace multiple substrings in one c... - Microsoft Fabric Community

[123abc]

PLEASE CAN YOU SAHRE THE PBIX SAMPLE FILE