By using this website, you agree to our Terms of Use (click here)
Hi everyone! I've been pulling in data from some General inquires that my company has in Acumatica, successfully, into Power BI.
However, the one report I really need I cannot get to work. I am able to connect to the feed, but it downloads just 114k of data, produces a table with correct column headers but all cell data is empty.
XML feed connect and returns, but empty as well.
Does anyone have any ideas? I'm on about hour 20 trying to get this work. Running out of ideas :/
I've attached some screenshots of my GI and what return in Power BI.
Thank you so much!
You can't use Parameters with OData: https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiries-parameters-and-odata/
You need to design the Query to not rely on Parameters. Your current conditions will return no data if the parameters are Null, which they will be in OData (you haven't tested for Empty[DateFrom] and [DateTo].
Hey Royce, you are a godsend. Thank you! As soon as I removed these the floodgates were opened. All systems go!
No worries at all. Glad to have helped out.
Also, if you need to do server-side filtering on OData, you can do it in the URL. See this Discussion Topic for more info:
Great, thanks Tim!