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
    Academy - Online Interactive Learning from Experts