Forum Discussion
How Power BI to connect Azure File Share?
To connect Power BI to an Azure File Share, you need to follow several steps. Here's a guide to help you do that:
1. Set up Your Azure File Share:
- Make sure you have an Azure File Share created in your Azure storage account.
2. Prepare Your Azure File Share:
- Upload the data files or content you want to access in Power BI to your Azure File Share.
3. Create a Connection in Power BI:
Open Power BI Desktop.
Go to the "Home" tab.
Click on "Get Data."
In the "Get Data" window, select "File" from the list of data sources.
Choose "Folder" and click "Connect."
4. Configure the Folder Path:
In the "Folder" dialog box, enter the UNC path to your Azure File Share. The UNC path should be in the format: \\<storage_account_name>.file.core.windows.net\<share_name>\<folder>
Click "OK."
5. Configure the Connection:
You'll be prompted to provide your Azure storage account name and the storage account key (or use a shared access signature) to authenticate. You can choose either method depending on your security requirements.
Once authenticated, you should be able to see the contents of your Azure File Share.
6. Load Your Data:
- Select the data files or folders you want to use in Power BI, and then click "Load" to import the data into your Power BI model.
7. Transform Data (if necessary):
- Depending on your data, you might need to apply data transformation steps using Power Query within Power BI to shape your data as needed.
8. Build Your Report:
- With the data loaded, you can now build your Power BI report and create visualizations.
It's important to note that while you can connect to Azure File Shares directly from Power BI, it may require some familiarity with Azure and Power BI, particularly regarding authentication and data transformation steps.
Also, ensure that your Azure File Share is properly secured, and you follow best practices for managing access and credentials, especially if your Power BI report will be shared with others.
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.