- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Slowness in SharePoint to PowerBI data loading
Hello,
I have basic knowledge of PowerBI and in my current use case, I am building a powerBI report. It has a live data connector to sharepoint lists which has 6000+ rows and 199 columns. I removed all unnecessary columns. There are columns which are in record form and I retrieve few columns from it. To be precise, 4 columns from 1 record by using convert to columns button and selected 4 columns. From another record, I selected 2 columns.
Question: When I apply changes data loads too slow starts with 1KB and goes into multiple of 2 KB. It takes 2 hours to load 75MB data. How should I improve performance of loading data? This mainly happens after I fetch columns from record. Also I am unable to use Implentation 2.0 while fetching data through SharePoint URL.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You can try using incremental refresh, or put the query into a dataflow and connect to that instead of directly to the list. That offloads some of the processing.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-03-2021 05:24 PM | |||
02-27-2024 12:22 PM | |||
12-02-2022 12:26 AM | |||
06-26-2024 05:52 AM | |||
Anonymous
| 05-27-2020 04:52 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |