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
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.
@Anonymous @lbendlin Hello, sorry, I connected it through SSAS database connection, which has worked fine previously.
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
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
"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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 56 | |
| 40 | |
| 36 | |
| 18 | |
| 18 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 38 | |
| 34 | |
| 23 |