Please will excel (I created the power in the excel pivot) imported into the power bi desktop prompt data size exceeds the maximum limit, but I watched the whole excel is not more than 1 g, and then some) values in the pivot and kpi not imported into the bi, the question should be how to deal with excuse me?

CodePudding user response:

You can directly from the Power BI Desktop import Power Pivot, so your model is imported directly

CodePudding user response:

refer to the original poster weixin_45342129 response:

will excel, please (I created the power in the excel pivot) imported into the power bi desktop prompt data size exceeds the maximum limit, but I see no more than 1 g under the whole excel, and then some) values in the pivot and kpi not imported into the bi, the question should be how to deal with excuse me?

The original poster to solve this problem, I also met the same problem
Prompt when have the XmlReader object is open, can't use the connection, how to do?