Currently when connecting to a new data source or manually refreshing an existing data set, we see "refreshing data" with a loading icon on the top right corner. Is there any way to see number or percent of rows being loaded? Sometimes data is being loaded for a long time and we might want to see if it's actually being loaded. Maybe we can gain insights on how to improve a specific data source too.
14 Comments
- nishalitNew MemberThanks Derrick! Anyone else think this would be a useful addition? Please add your vote!
- jamie15New MemberIt'd be useful to know how many rows have been returned from a query as well. Perhaps in the field well on the right hand side you could show us the number of rows in a query?
- jamie15New MemberI'm currently running a query in Power BI Designer. This is a very complicated query and takes minutes (sometimes hours) to run. In this case the query pulls data from a website, http://sqlblog.com, and as the query runs a modal dialog is shown saying: "Load
Waiting for sqlblog.com" Every so often a little message pops up telling me how much data has been loaded "X rows loaded". That message only appears for less than a second though. We need better feedback than this. How about keeping that message visible constantly? Better still, show it constantly incrementing as new rows are loaded. I'd expect to see that at the very least. - jirineoralPost PatronThis would be really useful, sometimes refresh hangs for 30 minutes and so for no apparent reason. If possible add stop button there as well. To manually kill refresh rather then to wait for failure
- ewuver1New MemberWhen is this feature coming up....
- AnonymousNot applicableI agree with the other commenters - When querying a very large data source, optimization is always very important. Without a progress bar showing (as a % value) how long it will take to refresh data, it's very hard to determine how successful our optimization efforts have been. It seems archaic to have to "wait it out" when things like progress bars exist. This is especially important due to the required refresh mechanic whenever queries are modified. It's maddening to have work on a report blocked for an undefinable amount of time because Power BI demands a full refresh to apply query changes, over and over again while I'm optimizing. Knowing how long a refresh will take at least makes it possible to plan around it.
- matt_korichNew MemberPlease update on this feature? At least give us access to logfiles showing progress and operations so we can tail them.
- PowerInter1New Membercan you add cancel refresh button , this will be very help full
- ioannis1New MemberDefinitely worth it, you could produce an analytics report based on the speed for loading each query just like when analysing a website loading performance, I update more than 50 tables each time and aim to optimise them but indeed feedback is limited. Also, ignoring errors when refreshing (especially auto refreshing) would be great.
- mihail_chigrichNew MemberGiven that PowerBI desktop shows exactly which data source and how many records are being loaded during a refresh, one would expect to have the same feature in the cloud version. It's disappointing that this is still not in place after being raised in 2014...
Recent ideas
Power BI Admin & Governance Center – Centralized Activity and Usage Analytics
Subject: Feature Proposal: Advanced Power BI Admin & Governance Center – Centralized Activity, Access, Sharing, Licensing and Usage Analytics Dear Microsoft Power BI Team, I would like to propose a...Dr7awb2 hours agoNew MemberNew1View0likes0CommentsFeature Proposal: Expandable/Collapsible Page Sections for Reports on Same Semantic Model
Subject: Feature Proposal: Expandable/Collapsible Page Sections for Reports Using the Same Semantic Model Dear Microsoft Power BI Team, I would like to propose an enhancement to the Power BI report...Dr7awb2 hours agoNew MemberNew1View0likes0CommentsFeature Proposal: Fault-Tolerant Refresh, Schema Changes & Intelligent Retry
Subject: Feature Proposal: Fault-Tolerant Refresh, Schema Changes & Intelligent Retry Dear Microsoft Power BI Team, I would like to propose an enhancement to Power BI semantic model refresh behavio...Dr7awb2 hours agoNew MemberNew5Views0likes0CommentsFault-Tolerant Table-Level Refresh, Retry & Completeness Monitoring
Subject: Feature Proposal: Fault-Tolerant Table-Level Refresh, Retry & Completeness Monitoring Dear Microsoft Power BI Team, I would like to propose an enhancement to the Power BI semantic model re...Dr7awb2 hours agoNew MemberNew1View0likes0CommentsAllow Measures to Be Grouped/Categorized in Matrices and Tables
Introduce the ability to group and categorize measures directly within Matrix and Table visuals, allowing report developers to organize large sets of measures into logical sections or expandable cate...Dr7awb2 hours agoNew MemberNew3Views0likes0Comments