Forum Discussion

RoskBI's avatar
RoskBI
Frequent Visitor
2 years ago

Power Bi Service - Data Privacy Refresh

Hi community,   I was hoping for some help.   I have a dashboard which pulls together all the current tenders from Australian Government states through their individual websites.   However, the...
RoskBI's avatar
RoskBI
Frequent Visitor
2 years ago

aj1973 One of the websites is here and publicly accessible. Please let me know if you think there is another way to get the data without hte Web.BrowserContents 

https://www.tenders.vic.gov.au/tender/search?keywords=&tenderCode=&tenderTitle=&tenderState=OPEN&tenderType=&categories%5B0%5D.id=104789&categories%5B0%5D.percentage=100&issuingBusinessId=&awardedSupplier.id=&awardedSupplier.name=&openThisWeek=false&openingDateFrom=&openingDateTo=&closeThisWeek=false&closingDateFrom=&closingDateTo=&awardedThisWeek=false&awardedDateFrom=&awardedDateTo=&groupBy=NONE&page=&searchTitle= 

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    The refresh in the service worked just fine without a Gateway

     

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    In your desktop connect to the web as Ananymous, then in Power Query open the Editor and change this to

     

    In the Service sign in this way

    You should be good

    • RoskBI's avatar
      RoskBI
      Frequent Visitor
      2 years ago

      I will give this a try this afternoon. Just to confirm will Web.Contents work with the "Add Table from Example" functionality?

      • aj1973's avatar
        aj1973
        Community Champion
        2 years ago

        I don't know, I have to try it my self.

        Give me the M Code please !