Here’s an updated version of the 2016 Houston home appraisal values Power BI report. I included a Trends tab that makes use of Power BI’s forecast feature to project the Average Appraisal Value and YOY Appraisal Change for the years 2017-2020. It’s interesting to note that while homes continue to appreciate in value, the amount […]
cLast week I did some research on how to render a Power BI report on a TV for the purposes of displaying it in an office. A good case scenario for this is if you have a help desk or service desk team and you want to show how each person on the team is performing and how they […]
Power BI and SQL Server Mobile Report Publisher (previously known as Datazen) are both Microsoft BI tools that offer mobile reporting capabilities. Mobile Report Publisher is part of the SQL Server 2016 release and provides on-premise mobile reporting functionality to SQL Server Reporting Services. Power BI is a standalone cloud-based service that provides similar mobile reporting […]
SQL Server Mobile Report Publisher does not have an intuitive way for moving a mobile report across servers, and I wasn’t able to find any documentation about this online. So how do you go about doing this? I came across a couple of options while testing different approaches, which are described below. If you have found a […]
I recently ran into a scenario where I developed a Power BI report against a SQL database using a live connection, and later developed a Tabular cube that I wanted to use to replace the SQL data source. As it turns out, replacing one live data source with another is not as straightforward as it […]
Below are some new (maybe old for some of you!) tips & hints that will come in handy when building new Power BI reports: Use the Shift + Arrow Keys to Move Items in Bigger Increments If you’re trying to get the location of a visual just right, and need to use the arrow keys instead […]
Have you ever been curious to know what the market value of your home is? Or how it compares to that of your neighbors? I had some of the same questions too, so I set out to look for a good dataset to build a dashboard on, and came across the Harris County Appraisal District’s (HCAD) […]
Since my last Power BI dashboard on weather analysis in the U.S., I’ve had a few requests and questions around the data I used to build the dashboard and how I transformed it into a CSV file. In this post I’ll provide a step by step walkthrough of the process I used, along with a copy […]
A few years back I got to work on a project for a client that was interested in relating weather data (rain precipitation, temperature, cloudiness, etc.) to their sales metrics in order to validate an assumption that the weather had an impact on how their sales performed in different parts of the country. During management meetings, […]
As Microsoft continues to release new product updates, and most recently with the launch of new reporting features in SQL Server 2016, I thought it would be a good idea to take a broader look at where Microsoft is planning to go in the future, and review how all of these reporting components fit together. On-Premises vs. […]
Thanks for sharing nice information about Hadoop and azure (...)
Hello, is there an option to have different folder color (...)
Thank you very much for such informations. but I want to (...)
Hi, I am exactly in the same problem. Even after 3 years of (...)
Hi this was really helpful. I'm using a digital solution (...)
Another option to add to this list for options to display (...)
There is a product called VuePilot that can help you with (...)
Good stuff! Go Reds
I am looking for a way to access the dashboard you (...)
Amazing post! Thank You for sharing such helpful (...)
Serena Williams is great player, but mostly wins from her (...)
Nice post. Is it possible to get a download of this .pbix (...)
When I use this method it does work, so thanks so much for (...)
Hi Craig - thanks. I've updated
Hello, it's great article. Is it possible somehow set (...)
Hey Victor, looks like the link to my site no longer works. (...)
Is there an option for full screen mode when using PowerBI (...)
Great post. no words to explain how thank you we
Hello, Thanks for this article! Any idea how to remove (...)
Lovely! Saved me a days work
What are the minimum rights necessary to be able to (...)
Good job ! Thank
OMG...Did not expect such a workaround could be available.I (...)
Hi AR - your calculated column only returns 8 clients for (...)
Activity = switch(true(), datediff(Clients[Last Activity (...)
Hi Venkat - I included link to download the file
Please share the PBIX
Hello, I am using Azure stream analytics to get telemetry (...)
This is awesome work, in one report you have handled many (...)
Thank
Hello Victor, it's fine now with lowercase thank you (...)
Hey Marin - make sure that "chromeless" is all lowercase. (...)
Hello, thanks for this tutorial it looks great (...)
Hello, thanks for this tutorial it looks great (...)
Hey Bob - check out this plug in for Chrome: (...)
Is there a way to rotate through multiple dashboards? We (...)
This is pretty neat. There's a new year out. I'm working (...)
Glad to hear that you found it
Very cool Victor! I'm getting ready to argue my property (...)
Thanks Adilson - I think both of them would
One quick note: The parameter, at the end of the URL must (...)
Hi Rashid - in that case you will need to map the server (...)
Hey thanks for the great post I am getting the same (...)
I am having a live screen running. One problem i faced is (...)
Hi , I have an issue with SSRS 2016 mobile reports. I tried (...)
Hi Judy - You will need the Enterprise version to use the (...)
Power BI reports in SQL Server Reporting Services can you (...)
Do you know if you need to have SQL 2016 Enterprise version (...)
Brutal!!!
Did you update the Twitter API keys with the ones from your (...)
Looks like I've got pass that but getting a " token has an (...)
Hi DS - can you try re-building the solution and seeing if (...)
Great blog post! I seem to get an error when running the (...)
[…] my last post I pointed out the different (...)