Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
Anonymous
Not applicable

OLAP data load refresh error

Hello, trying to do a data load but keep on getting these errors.
Object.png

 

 

 

 

 

 

 

 

 

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.


Screenshot 2021-04-08 180735_LI.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

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 4
Anonymous
Not applicable

@Anonymous @lbendlin  Hello, sorry, I connected it through SSAS database connection, which has worked fine previously.

Anonymous
Not applicable

HI @Anonymous,

What version of the power bi desktop are you work on? Did this issue appears after your update the power bi desktop client?

Regards,
Xiaoxin Sheng

Anonymous
Not applicable

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 Sheng

lbendlin
Super User
Super User

"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.

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.