Forum Discussion
Import Power Pivot, getting a size limitation error
Trying to import a Power Pivot model into PBI, but getting an error with the size limit. The table that's throwing an error has about 300K rows. I'm using the import option. I can't find any information on limits, and the error doesn't give any more detail that what's in the screen shot below. Anything I can do here?
Also can't find any documentation about local pbix size limitation. But this should caused by the data source which is connected by power pivot is very large. You may optimize the data model in power pivot(such as measure and calculate column which implement table scanning), also check if there's any link to other data source in power pivot, if there is, cut them off and check if this issue persists.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-yuta-msftCommunity Support
Also can't find any documentation about local pbix size limitation. But this should caused by the data source which is connected by power pivot is very large. You may optimize the data model in power pivot(such as measure and calculate column which implement table scanning), also check if there's any link to other data source in power pivot, if there is, cut them off and check if this issue persists.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.