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

Error when refresh data from power bi desktop / server which connect to SAP BW4HANA datasource

Dear All / Expert

 

       I have some issue when i try to change variable in the filter from BW query designer.

I have changed the variable from single variable into multiple single variable. After that i refresh the PBI in desktop as well as Service and i got below meesage. I have tried to change in back to the initial stage but the error still occurred

 

 

* _____________________________________________________________________________________________________________________*

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: COPA Information (Plan Vs Actual).

Underlying error message :1 arguments were passed to a function which expects 2.

DM_ErrorDetailNameCode_UnderlyingHResult : -2147467259

Microsoft.Data.Mashup.ValueError.Arguments : {{...}}

Microsoft.Data.Mashup.ValueError.Reason : Expression.Error

Cluster URI : WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net

Activity ID : 70d2b94a-ab13-47de-9b26-05a5e4b6ad48

Request ID : 796bfb08-b8a0-776f-132d-ffedde9000c4

Time : 2018-10-19 08:58:48Z

 

 Thank you

Wilathphon

1 ACCEPTED SOLUTION

Accepted Solutions
ouindia Frequent Visitor
Frequent Visitor

Re: Error when refresh data from power bi desktop / server which connect to SAP BW4HANA datasource

Hi Xiaoxin

 

         I will try to explain each step how can i come up with that error

Background

        Our project is using SAP BW as backend and connect with PBI using import mode

Requirement

        We would like to change our prompt from single selection to multiple selection

Step to re-produce the error

 

In BW4HANA

      1. I created new variable with variable type as multi single value (the variable that we change is the currency type) in BW query

      2. Change the exsiting variable into new variable from step 1

      3. Save and activate

In PBI

       1. Try to refresh the report

       2. the error occur as below

 

Updated: last friday i changed my query from multi selection into fixed value (Meaning i just filter it with value instead of variable) after changing the error still occurred, However, we try to refresh again this morning and it's working fine now. The report can refresh it.

 

Thank you
Wilathphon

View solution in original post

4 REPLIES 4
Highlighted
ouindia Frequent Visitor
Frequent Visitor

Urgent : Error while refresh data in PBI Desktop and Service connect with SAP BW4HANA

Dear All / Expert

 

        I am working with Power BI and SAP BW4HANA in the current project and i am facing some issue when i try to change variable in the filter from BW query designer. I have changed the variable from single variable into multiple single variable. After that i refresh the PBI in desktop as well as Service and i got below meesage. I have tried to change in back to the initial stage but the error still occurred

 

 

* _____________________________________________________________________________________________________________________*

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: COPA Information (Plan Vs Actual).

Underlying error message :1 arguments were passed to a function which expects 2.

DM_ErrorDetailNameCode_UnderlyingHResult : -2147467259

Microsoft.Data.Mashup.ValueError.Arguments : {{...}}

Microsoft.Data.Mashup.ValueError.Reason : Expression.Error

Cluster URI : WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net

Activity ID : 70d2b94a-ab13-47de-9b26-05a5e4b6ad48

Request ID : 796bfb08-b8a0-776f-132d-ffedde9000c4

Time : 2018-10-19 08:58:48Z

 

 Thank you

Wilathphon

Stachu Super Contributor
Super Contributor

Re: Urgent : Error while refresh data in PBI Desktop and Service connect with SAP BW4HANA

when you call the function, have you passed the second argument? it seems you call the function as if it was a single argument one
e.g. if original funstion was 

fnTransorm(var1 as text)

and you called it as

fnTransorm(var1Value)

if the function would be 

fnTransorm(var1 as text, var2 as text)

but you still call it the old way

fnTransorm(var1Value)
fnTransorm(var1Value, var2Value)

 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team
Community Support Team

Re: Error when refresh data from power bi desktop / server which connect to SAP BW4HANA datasource

HI @ouindia,

 

Can you please share some detail information of your queries table? According to error message, it seems like something wrong with your query steps.

 

Regards

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
ouindia Frequent Visitor
Frequent Visitor

Re: Error when refresh data from power bi desktop / server which connect to SAP BW4HANA datasource

Hi Xiaoxin

 

         I will try to explain each step how can i come up with that error

Background

        Our project is using SAP BW as backend and connect with PBI using import mode

Requirement

        We would like to change our prompt from single selection to multiple selection

Step to re-produce the error

 

In BW4HANA

      1. I created new variable with variable type as multi single value (the variable that we change is the currency type) in BW query

      2. Change the exsiting variable into new variable from step 1

      3. Save and activate

In PBI

       1. Try to refresh the report

       2. the error occur as below

 

Updated: last friday i changed my query from multi selection into fixed value (Meaning i just filter it with value instead of variable) after changing the error still occurred, However, we try to refresh again this morning and it's working fine now. The report can refresh it.

 

Thank you
Wilathphon

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 55 members 1,221 guests
Please welcome our newest community members: