The import Cube.AttributeMemberProperty matches no exports. Did you miss a module reference?

[Anonymous]

We face an issue with a query using SAP BW Properties (november feature). For that particular query the refresh with on-premise gateway failed with the following error. Others reports using this functionnality work well. In the desktop, refresh is also ok with that report. Any idea ?

Cannot connect to the mashup data source. See error details for more information.
Please try again later or contact support. If you contact support, please provide these details.

Underlying error code-2147467259 Table: Master Data - Client Regions.

Underlying error messageThe import Cube.AttributeMemberProperty matches no exports. Did you miss a module reference?

DM_ErrorDetailNameCode_UnderlyingHResult-2147467259

Microsoft.Data.Mashup.ValueError.ReasonExpression.Error

Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net

Activity ID7d951fb2-a7cf-9f46-fbc4-9f1c9b7da0fe

Request ID321faef2-9d20-25d9-6918-9fe1360078b3

Time2017-11-23 10:04:17Z

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Does the report only contain one data source (SAP BW)? Please check which action do you perform for Table: Master Data - Client Regions? How about remove issued Table: Master Data - Client Regions temporarily then republish to service to refresh again? Please back up original pbix file in advance. 

Please export gateway logs and share with us: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting

By the way, please try to update the on-premise data gateway to the latest version as well. 

Best Regards,
Qiuyun Yu

[Anonymous]

Hi @v-qiuyu-msft,

Right !

Regards.

[v-qiuyu-msft]

Hi @Anonymous,

It seems the issue is resolved now, right? 

Best Regards,
Qiuyun Yu

[Anonymous · Accepted solution]

Hello,

Thanks for the reply, yes it does contain only one datasource among manual entered data.

We did try to remove the failing query and the problem was gone.

After that we update the gateway to october version and it did solve the entire problem. We were still in a previous version (july by memory) whom seem to be incompatible with new SAP BW Properties features :

Thanks again for your help

Regards.

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Does the report only contain one data source (SAP BW)? Please check which action do you perform for Table: Master Data - Client Regions? How about remove issued Table: Master Data - Client Regions temporarily then republish to service to refresh again? Please back up original pbix file in advance. 

Please export gateway logs and share with us: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting

By the way, please try to update the on-premise data gateway to the latest version as well. 

Best Regards,
Qiuyun Yu