Forum Discussion
OLAP data load refresh error
Hello, trying to do a data load but keep on getting these errors.
I've used import and pulling the data from an Olap cube, the "Object reference not set to an instance of an object" error comes first if I load all the queries together and then it gives me the error in the picture below after pressing cancel on "Object reference".
The second error happens when I load all queries together and have "Enable Parallell loading of tables" disabled.
It's quite heavy about a 100 queries. I've tried to refresh the queries in a group of five which seems to work fine but when I try load 5+ queries I start getting this error. I have also tried to disabled "Enable Parallell loading of tables" & disabled all relationship options on data load and no luck with that either. I can't figure out why this happens, maybe somebody can nudge me in the right direction.
Thanks for your help.
4 Replies
"I've used import and pulling the data from an Olap cube"
Please explain the rationale behind that. Usually (...) OLAP cubes are connected to via Live Connection or Direct Query.
Hi Anonymous,
AFAIK, current power bi does not exist the olap connector. Did you mean the SSAS connector with live connection mode?
Since current power bi only allows you to use one live connection data source, did you enable the preview feature to use 'direct query' mode to connect data sources? If that is a case I'd like to suggest you take a look at following link about limitation of that feature:Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs
Regards,
Xiaoxin ShengAnonymous lbendlin Hello, sorry, I connected it through SSAS database connection, which has worked fine previously.
