Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Reference not work in PBI Web

  • 1.  Reference not work in PBI Web

    Posted Jan 15, 2020 03:44 AM

    Hi everyone

     

    I have a problem and I hope someone can help me

     

    I have built a data model whith many tables. The source is an URL. I have built a refenence becauce I must change a part of the URL for different customers.

     

    In PowerBI Desktop it works but in PowerBI Web the datasource is unknown.

     

    Here is the URL out of the advanced editor:

     

    >> each [ WebCall = Json.Document(Web.Contents(Text.Combine({"https://", Ref , "/xxx/api/v1/article/"}), <<

     

    The URL is the same until "v1/" and then it changes. I think I need the whole URL in PowerBI Web.

     

    Can you help?

     

    Thanks a lot in advance

     

    Eckhard Adden



    ------------------------------
    Eckhard Adden
    Consultant
    Emden
    ------------------------------
    Academy - Online Interactive Learning from Experts