|

Update on Data Query and Power BI

Words: it just might work (in reference to data query and Power BI updating without websites being open)

Back in December, I ran a test to see if Data Query and Power BI would update from the web so long as the website itself did not go away or its physical layout did not change. I tested the House of Representatives from Wikipedia and the State Temperatures from NOAA and they worked. Also, last time, I created a direct link to the NOAA state temperature data in Power BI rather than updating in Excel via data query and then feeding into Power BI. But in December I had the websites open.

I wanted to test the idea if data query and Power BI would still update even if I did not have the website open.

And that was what I did today.

And they WORKED!

Oh, this has possibilities…so long as the site’s physical layout does not change or the site does not go away.

Similar Posts

Some updates before the storm
| |

Some updates before the storm

Hi, before I get hit with some bad, bad weather coming my way, I thought I would do a little update on the coronavirus to “keep busy” during these anxiety producing times. Right now, I’m just sick in the stomach. Topic 1: 200K Milestone and year end projection First off, the U.S. just recently hit…

Shock! A new country in the top 10
| |

Shock! A new country in the top 10

I wasn’t going to do a post tonight but last night, when pulling in the latest set of numbers, something shocking jumped out at me: China became part of the top 10 countries in the world with the most daily cases over the last 14 days. I never really seriously tracked China largely because I…

Success Resolving Microsoft Updates - for the time being

Success! Conquering Microsoft Update Problems

After a couple of weeks, I have finally figured out what is going on with the “invisible” files. I was starting to feel useless and stupid. A couple of weeks ago, my macro stopped working because it could no longer see the downloaded files from our vendor even though the files were open and appeared…

Using Excel Custom List with GL Accounts
|

Using Excel Custom List with GL Accounts

A couple of posts ago, I wrote something about creating custom lists so that a list of items – could be products, could be departments – will automatically show up in the order you want when you do pivot tables or when you do autofill. Well, in this post, I am going to give an…

More Microsoft Updates - very buggy and messing up my machine.

More Microsoft Updates

Okay, Microsoft had done some more updates and now my computers are getting wonky. My work machine works slightly slower now and was initially giving me a black screen. My home machine now gives me a black screen for some minutes. I haven’t timed it yet, but it’s more than one minute, more like 10…