Send us a text

This week we look at big datasets.  And we should be clear, we are simply talking about large volumes - not "Big Data" as defined by volume, variety, and velocity.

We discuss options such as using Analysis Services to offload the data processing workloads away from Power BI.  Premium per User is now in public preview, so this could offer a more cost effective long term solution for managing large datasets in Power BI.

Direct Query does offer a last-resort solution but typically this is the least performant option, so should be used with caution since slow performance will put users off using the tool.

We discuss monitoring performance, and managing a changing landscape.  A report with a low volume of data today could become a large dataset in time and need the approach changing.

Finally, we come to data quality - and why it should get fixed at source not in the reporting tool.

You can download Power BI Desktop from here.

If you already use Power BI, or are considering it, we strongly recommend you join your local Power BI user group here.

To find out more about our services and the help we can offer, contact us at one of the websites below:
UK and Europe: https://www.clearlycloudy.co.uk/
North America: https://clearlysolutions.net/