Month: October 2021

image

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

Posted on by Summa Lai

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 Read More

image

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

Posted on by Summa Lai

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 Read More

image

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

Posted on by Summa Lai

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 Read More

image

Share and collaborate in My Drive

Posted on by Summa Lai

Share files and set access levels and visibility Note: If visitor sharing is on for your organization, you can invite someone who doesn’t have a Google Account to collaborate on your Google Drive files and folders. See Share documents with visitors. On the web Share a file or folder with specific people and set access levels: Select the file Read More