Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Advocate II
Advocate II

Sharepoint Folder vs. Azure Blob vs. Azure SQL Server vs. Azure Table

Hi Everyone. I have a question about what is the most efficient data connection for Power BI. Currently I am using Sharepoint Folder connection to pull in data from an ever growing stack of files. They are autogenerated once a day. I use Power BI to connect to the Sharepoint folder and read them all in. Loading the data is a bit slow, so I'm thinking there is a better way to do this with my limited data skills. Here are the options I am thinking of:


1. Create an Azure Blob storage and send the files there instead. This seems exactly like reading from a Sharepoint Folder, but maybe using Azure storage is faster or more efficient?  


2. Create an Azure SQL Database and read the files into a table there. This seems like the best solution, but I'm not great with managing SQL databases, so the learning curve makes this difficult. But if it is A LOT better then maybe it's worth it?


3. Create an Azure Table storage and send the data there. Honestly, not sure how this works, but considering these files are autogenerated and exactly the same format every time, i'm assuming this might be an option worth learning about. 


4. Keep on going with Sharepoint Folder. This is working just a bit slow and seems primitive. 


Any thoughts? Thanks. Jason

Community Support
Community Support

Hi @SHDJason ,

Based on your actual data volume, relationships among tables and the computational complexity, I can't give you a better advice. I researched some blogs that maybe help you a little bit.

Azure and Power BI

Introduction to Azure Storage

Introduction to Table storage in Azure

Different Azure Storage types (File, Blob, Queue and Table)

Transfer Files from SharePoint To Blob Storage with Azure Logic Apps


Best Regards,

Xue Ding

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

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

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors