Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Help with Web Query!

Hi Everyone,   I am in need of some help connecting to a web source that I can have updated every quarter.   I can establish a web query to the following link: https://data.bls.gov/cew/apps/table...
Need Help
tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
3 years ago

Hi Anonymous ,

 

I tried to find a way to change the row display settings in URL itself, but did not manage to do so...

 

Other people tried to use an API:

Bringing in api data from Bureau of Labor statisti... - Microsoft Power BI Community

 

And here they used the URL in combination with a function:

Solved: Trying to connect to Bureau of Labor Statistics, b... - Microsoft Power BI Community

 

I saw, however, if you press the Download Source Data button, you can get the underlaying source data in the csv format. This one you can call directly from the URL, too. Could this be something for you?

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/