On the data view is not possible to do a selection of more than one table but if you use the new relationship view you can select more than one table with CTRL + Left Click followed by right click and then remove the tables from the model.
Category: Power BI
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 Read 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
Power BI: Analyze in Excel – the Advanced Method
A common ask from users is the ability to view data related to visuals in excel. While there is an option to export data, the format is often unfriendly and has limitations. What’s more, this data becomes disconnected and is not updated if a user looks at after the data is refreshed. This post will Read More