cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jayita
Frequent Visitor

Error in Power BI while connecting to combined or virtual cube

Hi,

Getting error in Power BI for a simple count distinct field while connecting to a combined cube. E.g. No. of sales (count distinct done in BI4 dynamics) along with date and company dimensions.

While same is working fine if we take the No. of sales from Sales cube instead of combined cube (combined cube is Sales and Inventory combined cube). Other measures from the combined cube is working fine, only the count distinct is not working. Any clue anyone?

 

Error Message:
Internal error: An unexpected error occurred (file 'mdquerypart.cpp', line 1330, function 'MDQueryLinkedDetailJob::OnData').

7 REPLIES 7
v-zhenbw-msft
Community Support
Community Support

Hi @Jayita ,

 

What version of Power BI Desktop do you use?

What is the connect mode?

And what is the version of Power BI Desktop (32-bit or 64-bit)?

Could you please provide more detail information or screenshots? It will be helpful.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, 

Please find below detail:

 

Versjon: 2.85.681.0 64-bit (september 2020)

Connecting to SQL server Analysis server database.

 

Reports are based on cubes created in BI4 Analytics.

 

Thanks

Hi @Jayita ,

 

Do you use the Live connect mode?

Maybe you can create a new pbix file and connect your data source, select the import mode. Then try the measures again.

If it works in import mode, maybe the live connect mode doesn’t support some functions in your measure.

Perhaps you can create the measure in your data source mode, then connect it.

 

If it doesn’t meet your requirement, we suggest you to open a ticket here for help: https://powerbi.microsoft.com/en-us/support/

 

Support Ticket .gif

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the response.

 

Yes I am using Live connect mode.

Tried with Import mode and it is working fine.

 

Seems like the count distinct measure is working fine in Live connect mode if using One cube i.e. Sales cube but giving error while using combined/virtual cube.

 

Looks like bug or some limitations?

 

Thanks

Hi @Jayita ,

 

It was working fine in import mode, so the Live connect doesn’t support a certain measure.

Perhaps you can create the measure in your data source mode, then connect it.

 

Or maybe you can refer this thread to install the latest Service pack for your SSAS.

https://community.powerbi.com/t5/Desktop/New-Measure-Error-with-SSAS-Live-connection/td-p/193308

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your response.

But the same measure is working fine in Live connect mode if I connect to the particular cube i.e. Sales cube.

It is giving error when connecting to the combined cube i.e. sales and invntory cube.

So the issue seems to be only with the combined cube but not with standalone cube.

 

Thanks

Jayita

Jayita
Frequent Visitor

One more point: It is working fine while connecting from SSMS (same measure, same combined cube). Only issue while using Power BI for same.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.