Forum Discussion

Yass_Pbi's avatar
Yass_Pbi
Frequent Visitor
3 years ago

Use Web.contents( ) with Query & RelativePath parameters for Json Data List in Power Query M

Hello,   I want to parametrize this URL using Relative Path and Query functions inside Custom M Function, here my URL and my code: URL = "http://newapi.omni.com/1.13/Omni.svc/GetRelationListJson?j...
Need Help
Yass_Pbi's avatar
Yass_Pbi
Frequent Visitor
3 years ago

Hello Anonymous ,

 

Thank for different links.

 

I've tried all these workaround before, Unfortunately I have the same error in Power BI Service:

1. Combine all different queries in single one query.

2. Use Query parameter with Relative Path in URL

3. Set Privacy Setting in PBI Desktop to (Always Ignore Privacy Level).

 

 

 

Yass_Pbi's avatar
Yass_Pbi
Frequent Visitor
3 years ago

Hi all,

 

It works only with DataFlow, which means I need to upgrade all the licenses of my customer (Pro to PPU). It's very weird that we are obliged to use DataFlow to handle with this issue

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Yass_Pbi ,

     

    Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

     

    Best Regards,

    Neeko Tang

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

    • Yass_Pbi's avatar
      Yass_Pbi
      Frequent Visitor
      3 years ago

      Hello Anonymous ,

       

      I found a workaround ( Using DataFlow), so it's not solved yet with Power Query.

       

      Best regards,