image-2

How to Fix “Visual has Exceeded Available Resources” in Power BI

I’ve been using PowerBI for the better part of a year now. For the last couple of weeks, I had annoying failures to refresh for 6 of our 14 tile visualizations. It’s also inconsistent. Some days certain tiles are refreshed and others don’t.  I was able to get around this issue by identifying which table caused […]

image-2

How to Establish a Live Connection to a Power BI Datasets from Power BI Desktop

You can establish a live connection to a shared dataset in the Power BI service, and create many different reports from the same dataset. You can create your perfect data model in Power BI Desktop and publish it to the Power BI service. Then you and others can create multiple different reports in separate .pbix files from that […]

image-2

Power BI: How to Improve Refresh Speed (Odata and More)

When working with Power BI, sometimes the refresh speed is excruciatingly slow. This can seriously hamper the development time of your data analytics team. So what’s the best way to improve the refresh? Here are some tips I’ve discovered that will help to speed it up. Make the Power Query steps more efficient OData Filtering […]