Forum Discussion

primolee's avatar
primolee
Helper V
6 years ago
Solved

Web.Contents with dynamic file URL

I have searched through the community and found out about the limitation of Web.Contents on Power BI Service.  Data source is an Excel file in Sharepoint site, so I did some change to my codes.   f...
Need Help
  • aTChris's avatar
    aTChris
    6 years ago

    primolee 

     

    I've got it working. All ive done is set all URL's as parameters, I also added a space between parameters and the & in the functions. All minor stuff so this makes me think there is more to it.

     

    Anyway I uploaded it to my service updated the facebook file and refreshed and the clicks updated.

     

     

     

     

    I've updated the pbix with your sharepoint path, here are the files again.

    Download here 

     

aTChris's avatar
aTChris
Resolver I
6 years ago

primolee 

 

I've got it working. All ive done is set all URL's as parameters, I also added a space between parameters and the & in the functions. All minor stuff so this makes me think there is more to it.

 

Anyway I uploaded it to my service updated the facebook file and refreshed and the clicks updated.

 

 

 

 

I've updated the pbix with your sharepoint path, here are the files again.

Download here 

 

CWPRenewables's avatar
CWPRenewables
Frequent Visitor
5 years ago

Hi aTChris,

I have a very similar problem, and now reading more on this post, I realise why my solution hasn't worked.

I would like to look at your solution to try and understand it, as I don't quite understand what you mean by "set all URLs as parameters", but there the Download path is dead.

Any chance you could take a look at my post and comment?

https://community.powerbi.com/t5/Power-Query/SharePoint-Sites-Authentication-as-part-of-Web-Contents/m-p/1759967#M53132