|

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

Changing the Accounting Again
|

Changing the Accounting Again

This gets old – the company that is in or was just in bankruptcy keeps changing its books. Every month my boss does variance analysis against the budget that was created earlier in the year (and not forwarded to the sites that have to manage their money, go figure). I gather the data for her since…

To solve a problem – ask 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…

The Rally is Tomorrow and the Coronavirus is Still Spreading
|

The Rally is Tomorrow and the Coronavirus is Still Spreading

Every time WordPress does its update on its Block Editor, I have to experiment with various plug ins activated or deactivated to be able to do a new post because something always come up broken. Sometimes I’ll be able to get the Gutenberg block editor and other times I can’t. Today is one of those…

Two Parts: Yikes! and Dates in Power BI
|

Two Parts: Yikes! and Dates in Power BI

Yesterday, after I finished posting my blog post, I did my usual evening pull down of data and review of the latest results. And yikes! Graphically, it looked like the cases jumped so I’m going to briefly talk about those before heading to my original topic: dates in power BI. That second topic will be…

Data Changed
| |

Data Changed

My state changed the way they lay out the data: some file names changed, some tab names changed, layout changed and some of the data itself changed. I had to spend time reviewing the changes and mapping the files to the old files to determine what I needed to do when changing my programs. I…

Various Activities Going On
|

Various Activities Going On

I am time crunched right now as I am working on the ACA, so I will stick to some quick notes on a couple of things. How come I haven’t thought of this before? Two or three weeks ago, I was reviewing some numbers, especially looking for things such as “#N/A” or “#VALUE!” or “#DIV/0!”….