mrmmickle1
Well-known Member
- Joined
- May 11, 2012
- Messages
- 2,461
I'm pretty new to Power BI and I have been doing a little bit of testing. So far I have created a connection to an Access Database. The tables I connected are Temporary tables. I did this on purpose because I load different data sets in these tables all the time based on Line of Business Criteria. I wanted to load a few different data sets to see how different LOB specific scenarios would appear.....
Scenario:
1. I loaded LOB A data into the temp tables (1,500 + rows)
2. I created some visualizations in Power BI
3. I realized these weren't really representative of most of my data so I update the temp tables in Access ....enlarging the data set to 200,000 + rows
4. I refreshed the data in Power BI (Big Button on Home tab & tried to go to the table directly and refresh there as well)
5. Data still reflects 1,500 rows....
Why can't I get the data to refresh? Looking at the Access table...I know there are 200,000+ Rows. Why does Power BI still show 1,500?
Scenario:
1. I loaded LOB A data into the temp tables (1,500 + rows)
2. I created some visualizations in Power BI
3. I realized these weren't really representative of most of my data so I update the temp tables in Access ....enlarging the data set to 200,000 + rows
4. I refreshed the data in Power BI (Big Button on Home tab & tried to go to the table directly and refresh there as well)
5. Data still reflects 1,500 rows....
Why can't I get the data to refresh? Looking at the Access table...I know there are 200,000+ Rows. Why does Power BI still show 1,500?
