Forum Discussion

ashmitp869's avatar
ashmitp869
Responsive Resident
8 months ago
Solved

Assistance with Power BI Power Query M Code

I am using Power BI to connect to the Myosh API via the Web API option. Currently, I select Type: Anonymous and Privacy Level: Organizational.   Using the base URL directly, I can successf...
Need Help
  • ashmitp869's avatar
    ashmitp869
    8 months ago

    Hi PhilipTreacy 

    I found the correct one, I was missing {} 

    filter = {"moduleName:Incident Reporting", "archivedStep:true", "form:2"}

     

PhilipTreacy's avatar
PhilipTreacy
Super User
8 months ago

ashmitp869 

 

What results are you getting when using RelativePath?

 

I notice that in the 2nd query above you have this query parameter

 

filter = "=moduleName:Incident Reporting&filter=archivedStep:true&filter=form:2"

 

but shouldn't that be this (without the leading = in the parameter value)

 

filter = "moduleName:Incident Reporting&filter=archivedStep:true&filter=form:2"

 

Regards

 

Phil

  • ashmitp869's avatar
    ashmitp869
    Responsive Resident
    8 months ago

    Hi PhilipTreacy 

    I found the correct one, I was missing {} 

    filter = {"moduleName:Incident Reporting", "archivedStep:true", "form:2"}