Forum Discussion

residentx's avatar
residentx
Helper IV
10 years ago

Lightweight BI Tool

I'm trying to build some models and I'm just running into errors everywhere with the tool.   1. Bugs I had memory liimits and other execution errors.   2. Loading I had two keep problems with t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

residentx Why are you importing your models into Excel, and then loading them into the Desktop? Are you trying to leverage existing visuals, etc? If your model is extremely large, you should consider using the Direct Query approach.

The other issue you face with your approach, is that the PBIX (Desktop file) can't be larger than 250mb.. so if you are hitting errors now... it's likely that you'll encounter errors trying to publish to the Service.

residentx's avatar
residentx
Helper IV
10 years ago

I try to clean up everything before I bring it back into PowerBI

 

  • residentx's avatar
    residentx
    Helper IV
    10 years ago

    Power BI can build connections automatically so if I can format my datasets right they'll just plug in.

    Also, I had to use excel because some of my datasets exceeded the limits of excel and I need a powerpivot model.