Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI Desktop won't Accept Excel File on OneDrive that Contains "%5F" in File Name

Hi everyone,    I just noticed a problem that if there is a Excel file on OneDrive for Business, and it's name contains "%5F" or any other HTML encoding characters, the Power BI will failed to conn...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You can connect to the excel file located in OneDrive for Business using Web connector, please pay attention to the detail steps: Use OneDrive for Business links in Power BI Desktop.

 

Note that for the " ?web=1 " string at the end of the link , you must remove that portion of the Web URL string before selecting OK

 

 

Best Regards,

Amy

 

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

That's exactly what I did. BUT if your Excel file name contains "%5F" or any other URL encoded characters, this will not work. I guess because Power BI is try to decode "%5F" as "_", which is wrong file name now. For example, I have a file called "Weekly%5FProduction.xlsx" on OneDrive, but Power BI decoded "%5F" and looking for "Weekly_Production.xlsx" instead.