Forum Discussion
Import table with filters from a web page
Hi Anonymous ,
I'm afraid it's unavailable.
If you connect to SQL server, you could filter data before the data is imported into PBI, you can click Get Data->advanced options and write some SQL statements to achieve data you want.
If you want to filter data from a web page, you could filter data in power query after imported.
Tutorial: Import and analyze data from a webpage - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserAnonymous Anonymous
I think we're thinking about different things. If the web page is only showing the data on the page that is specified by the filter, perhaps the URL applies the filters, then you can get that data as is.
I'd need to see the website to check how the filtering works and understand what you mean. Can you provide the URL?
regards
Phil
The url is - https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=9810002201
I wanted to import the first table which has the filter on for Canada, Newfoundland and Labrador and so on. Basically, I want to import the whole table (including the filters).