|

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

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…

One Person Can Now Run Three Reports
|

One Person Can Now Run Three Reports

Last week I found out that somebody was backfilling for two other people and therefore, was running three reports. If I hadn’t automated the report, she wouldn’t have been able to do that. It’s pretty exciting to be able to cut down the time drastically, but it is also scary. Fewer people will be required…

Creating Measures in Power BI
|

Creating Measures in Power BI

A couple of posts ago, when I was discussing the three ways of creating calculations (measures, new columns in Power Query, and new columns in the charting/visualization view), there was at one point in the post an image of 2 moving average measures and I mentioned that I would do a post about why I…

Listen and Collaborate
|

Listening to My Customers

We’re on our third year with our automated operational reporting, which has been rolled out to both sides of the house. It kind of gives me a secret thrill to think that once a week, everyone comes in to work in the morning, opens up the file and lets the program do its magic. And if they…

Simple “Predictive” Analytics
| |

Simple “Predictive” Analytics

What if your company is not on the analytics kick or does not make enough money to afford those fancy software tools advertising predictive analytics or some kind of analytics? What if your peers simply do not have any interest in exploring how to use data and find valuable information? You might still be able…