Forum Discussion
Dynamically change where statement from slicer selection
Hello - We're beginners at Power BI and are running into an interesting problem. We have a table with over 5.9M rows. We only need to display one customer at a time which brings the max rows to ab...
JLEmlet what is the motivation behind not wanting to import all 6M rows? 6M rows is really not very large in terms of what Power BI can handle, and your performance is likely to be significantly better if you are using Import mode versus DirectQuery.
The data in the underlying table updates about every 20 to 30 minutes. So we want the power but I report to Always have the latest data, and we're deploying it to the Power BI website. That only allows a seven updates per day. So we're going for a Live connection to the data source. I guess another option would be to create a tabular cube And have that refresh every time the data refreshes. Any ideas?