|

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

Macros - asking the right question

To solve a problem – ask the right question

Earlier this past week, I was trying to write up a macro program to delete a specific picture that had been copied over from a download. With the intent of keeping the process simple for the users of this file,  part of the process involved copying the entire download, including a picture of a graph. This is fine…

Whirlwind

Whirlwind this week

It’s been busy the last week and a half so I haven’t done much posting. Really, haven’t done much of anything but work. We did our training for the new report file and next Monday we start our trial run. The whole month of December will be testing, debugging, getting familiar, and finalizing process. Oh,…

Can you see the light at the end of the tunnel?
| |

Can you see the light at the end of the tunnel?

If you can’t see it, that’s because it will be a couple of more months, if not a year, before we start to see the coronavirus tamed. A couple of factors for this dismal outlook: 1. We did a lot of traveling over the holidays despite warnings from health officials. Here are the TSA travel…

Automating the Budget

Automating the Budget Process

It’s budget season again and we’re back to trying to make the budget file better. Because of the nature of our business, we have sites that use different sets of GL account codes which makes creating a single budget file problematic. But my boss is a master of Excel. Most people would create three separate files but…

Attempting Text Analysis
|

Attempting Text Analysis

Lately, I’ve been trying to figure out how text analysis work. Last year, when I was looking at some comments, I created a dictionary of similar phrases so I could see trends in comments – what kind of comments are mentioned most frequently. In the business I’m in, certain phrases come up frequently so one…