Forum Discussion
DataFormat.Error: The input URL is invalid. Please provide a URL to the file path on SharePoint up t
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.
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 with file path parsing12.
To avoid this issue, you can try the following solutions:
- Rename the File: Remove or replace the # character in the file name.
- Use Encoding: Ensure the file path is correctly encoded in your query.
- 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
3 Replies
PLEASE CAN YOU SAHRE THE PBIX SAMPLE FILE
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 with file path parsing12.
To avoid this issue, you can try the following solutions:
- Rename the File: Remove or replace the # character in the file name.
- Use Encoding: Ensure the file path is correctly encoded in your query.
- 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