Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Has anyone else had the same issue , I had an error connecting to an Excel sheet on a local drive. So I checked it was not pointing a a hard coded drive C;\ but at the actual link \\ . I managed to fix it by amending from '20170101 – ABC.xlsx' to 20170101_ABC.xlsx has anyone else come across any naming conventions that caused an issue ?
Solved! Go to Solution.
@KarlCullimore,
What error message do you get? I have no issues connecting to the Excel file which has spaces in file name under gateway, please review the following screenshot.
Regards,
Lydia
@KarlCullimore do you have spaces before and after the dash?
Data Management Best Practices for file naming recommends to:
Thats why when you changed it to a 20170101_ABC.xlsx it worked.
BR
BR
Thanks @Bordalos it did indeed have spaces before and after. As I need to update my company docs for our self service contingent, I could do with knowing whihc microsoft site this comes from so that I can add it to company documentation on the Power BI gateway. If you have a link that would be very much appreciated.
@KarlCullimore,
What error message do you get? I have no issues connecting to the Excel file which has spaces in file name under gateway, please review the following screenshot.
Regards,
Lydia
Hi Lydia,
I cannot reproduce , the error message was an unable to connect issue. But it currently reading as connection succesful. Im blaming the hidden character issue.
Thanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!