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 dashboard relies on websites and when using Power BI Service to refresh, it won't let me refresh the data and based on privacy issues (screenshot below). In Power BI Desktop all the datasources privacy is set to "None" and I am unsure on what else could be causing the error.

Hi RoskBI This might be the problem

Hi Amine, Thanks for that. I understand it's a privacy issue but unsure how I am supposed to provide privacy levels anywher else? I have set privacy levels in Power BI Desktop and Power Bi Service through the Data Gateway. Am i missing something?

HiI am not sure whay would you need a Gateway !?Can you check out this pleasehttps://community.fabric.microsoft.com/t5/Service/Gateway-needed-for-web-data/m-p/723034

Hi Amine, It's unfortunate as the websites don't have "Tables" to pull the data cleanly sorry. I need to use the create table from example tool. As such, I need to use Web.BrowserContents which requires a gateway for refresh (Extremely frustrating haha)

You might want to look here too

Power Bi Service - Data Privacy Refresh | Microsoft Fabric Community

15 Replies

aj1973
Community Champion
2 years ago
Hi RoskBI
This might be the problem
- RoskBI
  Frequent Visitor
  2 years ago
  Hi Amine,
  
  Thanks for that. I understand it's a privacy issue but unsure how I am supposed to provide privacy levels anywher else?
  
  I have set privacy levels in Power BI Desktop and Power Bi Service through the Data Gateway. Am i missing something?
  - aj1973
    Community Champion
    2 years ago
    Hi
    I am not sure whay would you need a Gateway !?
    Can you check out this please
    https://community.fabric.microsoft.com/t5/Service/Gateway-needed-for-web-data/m-p/723034
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
  Community Champion
  2 years ago
  The refresh in the service worked just fine without a Gateway
- 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
    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?