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
Category: Microsoft Family
Microsoft Windows Servers, AD, Exchange, Azure, Windows 10, Office 365 and more
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 Read More
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 Read More
How to Increasing the Timeout Parameters for PowerBI oData Feeds
For particularly large oData exports it can sometimes be helpful to increase the default PowerBI timeout period. This is easily done in the advanced editor of the Power Query Editor. 1) To access the Power Query editor click the options menu on your table and select Edit Query 2) In Power Query select the Advanced Editor Read More
Understand Excel File Types, XLSX, XLSM, XLSB, and More.
When you save an Excel workbook for the first time or use the “Save As” function, you are asked for a folder, file name as well as the file type. By default, Excel suggests the XLSX file type (unless your file doesn’t have VBA macros). The window looks similar to the screenshot on the right Read More
Excel VBA, How to Delete Entire Row if Contains Certain Text
Question I’ve searched on here, but every code I put in gives me an error back. Data in column D, If any of the cells contain “Record Only” I need it to delete the entire row. Solution