Need Help Establishing Web Query

[Anonymous]

Hi all,

I need to establish a web query to this page on the Bureau of Economic Analysis: https://apps.bea.gov/itable/?ReqID=70&step=1&acrdn=5#eyJhcHBpZCI6NzAsInN0ZXBzIjpbMSwyNCwyOSwyNSwzMSw...

It has to be a web query so I can refresh the data.

The issue is that Power Query does not scan the table. 

Any help would be extremely helpful!!

Cheers!

[Anonymous · Accepted solution]

Hi @Anonymous ,

In many cases, the data displayed on the web side is rendered or encrypted before it is displayed on the front end. At this point the web connector cannot discover these tables.

You might consider contacting the site administrator to see if they are willing to provide an API for calling this data.

Or download the files regularly through a script and update them to the folder automatically, using a desktop connection to the folder and refreshing the data source through the On-premises data gateway.

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum