Forum Discussion
How Power BI to connect Azure File Share?
Hi 123abc ,
Thanks for your prompted solution. At Step 4 Configure the Folder Path, are you trying to say this the Folder window to insert the UNC path? Please refer to this screenshot below.
I tried it, I got one error window showed that "Details: "We got the IO error '53' while trying to access the path '\\XXX.file.core.windows.net\mysharedfilename\folderName\*'." Just to share with you, I did not put any symbol character after my folder name. My path is same format as what you shared, but after I clicked "Connect" button then appear this error.
I see that you encountered an error while trying to configure the Folder Path in Power BI when connecting to the Azure File Share. The error message "IO error '53'" typically indicates a network-related issue. Here are some troubleshooting steps you can follow to resolve this issue:
1. **Check Network Connectivity**:
- Ensure that your computer has internet access and can reach Azure services. If you are behind a firewall or proxy, make sure it's not blocking access to Azure.
2. **UNC Path Format**:
- Ensure that the UNC path you are using is in the correct format: `\\<storageaccount>.file.core.windows.net\<sharename>\<foldername>`. Verify that there are no typos in the path.
3. **Firewall Rules**:
- Verify that your Azure Storage account's firewall rules allow access from your IP address or network range. You may need to add your local IP address to the allowed list.
4. **Access Key**:
- Ensure that you have the correct access key for your Azure Storage account. You need the access key to access the Azure File Share.
5. **Shared Access Signature (SAS)**:
- Alternatively, you can try using a Shared Access Signature (SAS) URL for the Azure File Share. SAS URLs provide time-limited access to your data. You can generate a SAS URL from the Azure Portal and use it as the Folder Path in Power BI.
6. **Firewall or Anti-virus Software**:
- Temporarily disable any firewall or anti-virus software that might be interfering with the connection. Be sure to re-enable it after testing.
7. **Power BI Updates**:
- Ensure that your Power BI Desktop application is up to date. Sometimes, issues are resolved in newer versions.
8. **Power BI Service**:
- If you are able to establish a connection in Power BI Desktop but encounter issues when publishing to Power BI Service, make sure that the same UNC path and credentials are configured in the dataset settings in Power BI Service.
9. **Consult Azure Support**:
- If the issue persists, and you've checked all the settings and configurations, consider reaching out to Azure Support for assistance with Azure File Share connectivity.
Remember to handle access credentials, such as access keys or SAS tokens, securely and avoid sharing them in public places. Troubleshooting network-related issues can sometimes be complex, so don't hesitate to involve your organization's IT or network administrators if needed.