Cart works well in desktop but not on web

[Anonymous]

HI there!

I have created report which has been working well for past 1 year but recently cart stoped working on Web where as it works well on desktop

not sure what is the issue. The switch account it just point to columns. Below is switch account . Do let me know your comments

Switchaccount =

SWITCH(SELECTEDVALUE('INVOICE DETAIL'[FIELD]),

"ENTITY",SELECTEDVALUE(Entity[Entity]),

"VENDOR CODE",SELECTEDVALUE(Supplier[Supplier Number]),

"VENDOR NAME",SELECTEDVALUE(Supplier[Supplier Name]),

"VENDOR SITE",SELECTEDVALUE('Supplier Site'[Supplier Site Name]),

"INVOICE DATE",SELECTEDVALUE('Invoice Headers'[Invoice Date]),

"INVOICE NO",SELECTEDVALUE('Invoice Headers'[Invoice Number]),

"INVOICE AMOUNT",SELECTEDVALUE('Invoice Headers'[Invoice Amount]),

"CURRENCY",SELECTEDVALUE('Invoice Headers'[Invoice Currency]),

"INVOICE UPDATE DATE",SELECTEDVALUE('Payment Headers'[Payment Date]),

"PO NO",SELECTEDVALUE('PO Headers'[PO Number]),

"PO DESCRIPTION",SELECTEDVALUE('PO Headers'[PO Description]),

"APPROVER STATUS",SELECTEDVALUE('Invoice Headers'[Approval Status]),

"DUE DATE",SELECTEDVALUE('Invoice Headers'[DWH_UPDATE_DATE.1]),

"PAYMENT INFORMATION STATUS",SELECTEDVALUE('Payment Headers'[Payment information status]),

"PAYMENT AMOUNT",SELECTEDVALUE('Payment Headers'[Amount]),

"PAYMENT DATE",SELECTEDVALUE('Payment Headers'[Payment Date]),

"CHECK NUMBER",SELECTEDVALUE('ORACLE AP_CHECKS_ALL 3'[CHECK_NUMBER],

" - "

))

[Anonymous]

HI , Thanks for your message , 

This has been working for past 1 year and not sure why cart is not working now in web
its not about the gateway 

[v-henryk-mstf]

Hi @Anonymous ,

Which schema are you connecting to the data source through? If it is direct query mode, then after publish to servie you need to create the gateway and configure the credentials of the corresponding data source. The data in the data source can only be accessed properly when interacting with it.

If the problem is still not resolved, can you provide more relevant information? (specific error messages, screenshots of your steps, etc.). Looking forward to your reply.

Best Regards,
Henry

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