Do you have measures spread across multiple tables ? Is it getting hard to find the measures ? Check out this video which talks about organizing measures. https://www.youtube.com/watch?v=w8wPyYatzMo
Author: nikilprabhakar
Power Query – Merge Function
Can I use merge function to filter data ? Yes you can and there are gotchas... Listen to the post for details: https://www.youtube.com/watch?v=ycb4qzo0nhE&t=128s
Power Query – Create Functions
How hard is it to create functions in Power Query ? Do I need to learn coding to write functions ? When should I create functions ? I answer these questions in the following post: https://youtu.be/XGlTcgELxG4
Power BI – SAP Connectors Part 3 Large Data Volumes
In this post, I cover strategies to deal with large data volumes when using SAP connectors in Power BI. https://youtu.be/snw6gpWYuTc
Power BI – SAP Connectors Part 2 Enable Trace
How to get to the log files when using SAP BW as the data source ? I answer this in the post below. https://youtu.be/7WfFDGfR6v4
Power BI – SAP Connectors Part 1
In this post, I cover things I have learnt and best practices using SAP Connectors in Power BI. Direct Query vs Import mode, Relational vs Multidimensional mode... etc. https://youtu.be/w2Vt-oGhmxU
Power BI: Control Dataset Size Using Parameters
In this post, I cover the steps to use parameters to control dataset size. Check it out. https://www.youtube.com/watch?v=7ipslDgCtss&feature=youtu.be
SAP HANA Connector – Incremental Refresh
A lot of my clients ask the following question: "Hey I am connecting to SAP HANA using import mode. I need to bring multiple years of data into Power BI for YoY analysis. This means millions of rows of data. When I try to refresh this dataset, it takes hours to complete and in most … Continue reading SAP HANA Connector – Incremental Refresh
SAP HANA Connector – HANA view design to improve performance
As we know SAP HANA Connector is used to connect to SAP analytical and calc views. Sometimes HANA view might get complex and deep - it might have numerous joins, aggregations and the join might be between two fact tables (e.g. a join between Inventory and Sales tables). View might end up looking something like … Continue reading SAP HANA Connector – HANA view design to improve performance
SAP HANA Connector – Effects of creating measures in Direct Query mode
As we know SAP HANA Connector can be used in both Direct Query and Import mode. When using Direct Query mode, we do get the option to create measures in Power BI. Not all DAX functions are supported. Aggregations like SUM, MIN, MAX, COUNT, DISTINCTCOUNT are the only ones supported. We need to be careful … Continue reading SAP HANA Connector – Effects of creating measures in Direct Query mode