File<\/td> SampleSuperstore.xlsx<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nMake the resource types accessible via SAS<\/h3>\n\n\n\n To make the resource types accessible via SAS, go to your Azure Storage account page. On the left side of the page, find the Security + Networking section and click on “Share access signature”.<\/p>\n\n\n\n
Then, select the checkboxes for Service, Container, and Object. This will allow you to grant access to these resource types via a SAS (Shared Access Signature) token.<\/p>\n\n\n
\n
<\/figure><\/div>\n\n\nClick on the “Generate SAS and connection string” at the bottom of the page:<\/p>\n\n\n
\n
<\/figure><\/div>\n\n\nCongratulations! Your Azure account is now ready to use.<\/p>\n\n\n\n
Connect Azure Blob Storage to Power BI Desktop<\/h2>\n\n\n\n To start with, open Power BI Desktop and click on the “Get Data” button on the Home tab. Next, select “Azure Blob Storage” from the list of available data sources, and click on “Connect”.<\/p>\n\n\n
\n
<\/figure><\/div>\n\n\nIn the “Azure Blob Storage” dialog box, you will need to enter the following information: the name of your Azure Blob Storage account.<\/p>\n\n\n
\n
<\/figure><\/div>\n\n\nNext, the container name you created earlier, and the access key for your Azure Blob Storage account.<\/p>\n\n\n
\n
<\/figure><\/div>\n\n\nThen click on “OK” to connect to your Azure Blob Storage account.<\/p>\n\n\n\n
NB: To connect to Azure Blob Storage in Power BI, you must first create a container and upload data to it using Azure Storage Explorer, AzCopy, or the Azure portal. Thereafter, follow the above steps to connect to your account in Power BI.<\/em><\/p>\n\n\n\nFAQs: How to Connect Azure Blob Storage to Power BI Desktop<\/h2>\n\n\n\nWhat is Azure Blob Storage?<\/h3>\n\n\n\n Azure Blob Storage is a cloud-based storage solution made by Microsoft Azure that allows users to store unstructured data including images, videos, documents, etc.<\/p>\n\n\n\n
Can I connect to multiple Azure Blob Storage accounts in Power BI?<\/h3>\n\n\n\n Yes, you can connect to multiple Azure Blob Storage accounts in Power BI. To do that, just repeat the steps outlined in this article for each account you want to connect to.<\/p>\n\n\n\n
Can I connect to Azure Blob Storage in Power BI without an access key?<\/h3>\n\n\n\n No, you need an access key to connect to your Azure Blob Storage account in Power BI.<\/p>\n\n\n\n
Is it possible to load real-time data from Azure Blob Storage into Power BI?<\/h3>\n\n\n\n Yes, you can load real-time data from Azure Blob Storage into Power BI by configuring real-time data streaming using Azure Stream Analytics.<\/p>\n\n\n\n
How can I troubleshoot Azure Blob Storage to Power BI data loading issues?<\/h3>\n\n\n\n To troubleshoot connection issues, check that your access key, container name, and storage account name are entered correctly.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n I hope you found this article on how to connect Azure Blob Storage to Power BI Desktop helpful.<\/p>\n\n\n\n
In this article, you have learned:<\/p>\n\n\n\n
\nhow to create an Azure account and upload a sample xslx dataset.<\/li>\n\n\n\n connect Azure Blob Storage to Power BI Desktop<\/li>\n<\/ul>\n\n\n\nAnd with the steps explained in this article, you should now easily integrate your Azure Blob Storage data into your Power BI reports and create powerful visuals that can help to make informed business decisions.<\/p>\n\n\n\n
Don’t forget, if you ever need a refresher, you can always come back to this article for a quick reminder.<\/em><\/p>\n\n\n\nIf you enjoyed reading this, you can as well read how to connect Power BI to SQL Server Stored Procedures.<\/a><\/p>\n\n\n\nHappy analyzing!<\/p>\n","protected":false},"excerpt":{"rendered":"
This Power BI project explores how to connect Azure Blob Storage to Power BI Desktop, even without prior experience. Fortunately, … <\/p>\n
Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":7273,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,8],"tags":[],"yoast_head":"\nHow to Connect Azure Blob Storage to Power BI Desktop - Monocroft<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n \n \n \n\t \n\t \n\t \n