Skip to main content
Answer

Odata in POwer BI

  • April 25, 2025
  • 2 replies
  • 57 views

Forum|alt.badge.img+3

Hi All. I am trying to get BI Ar-Invoices data into Power BI using query filter by invoice date. But on querying it shows me either authentication error (even i am admin) or some time

 

 

 My query is :
https://local.acumatica.com/odata/BI-ARInvoices?$filter=InvoiceDate ge datetime'2025-04-03T00:00:00'
Do I need to run the query in Postman and then import that data into Power BI? Please suggest a better approach

 

Thanks

Best answer by DipakNilkanth

Hi ​@tahayabali,

It’s not necessary to use Postman every time. However, for this case, you should run the query in Postman to get the specific response and better understand the issue.
Please try running the query in Postman and check what response you are getting — it will help in identifying the root cause more quickly.

Hope, it helps!

2 replies

DipakNilkanth
Pro III
Forum|alt.badge.img+13
  • Pro III
  • Answer
  • April 26, 2025

Hi ​@tahayabali,

It’s not necessary to use Postman every time. However, for this case, you should run the query in Postman to get the specific response and better understand the issue.
Please try running the query in Postman and check what response you are getting — it will help in identifying the root cause more quickly.

Hope, it helps!


Forum|alt.badge.img
  • Jr Varsity III
  • April 26, 2025

@tahayabali  can you please confirm whether you are using Odata feed or API connection?

If you are using Odata connection then please let me know the steps which you are doing.

Thanks