I suspect that many of you have looked at the title of this video and immediately thought that I was just being silly and provocative. And, generally speaking, you would be right as I do enjoy a fair amount of silly and provocation every now and then. However, in this case, even though I do … Continue reading Is Snowflake One Bad Quarter Away from Being Microsoft Power BI Biggest Threat?
Should Microsoft be worried that Salesforce has just acquired Slack? In my opinion – YES, in fact it should be so worried that it must double its investments in Power BI.
Vlog #2 is up… I talk about the channel growth – 10% in the last week – thank you! I also go over the latest Power BI updates from the team's blog. Basically, nothing super exciting, other than a few cool things that get us closer to a direct query to AS or PBI composite … Continue reading KNOWLEDGEBANK.PRO VLOG #2: Channel Update, Two Custom Visual Reviews and a Bit of Ranting
In this post, I cover strategies to deal with large data volumes when using SAP connectors in Power BI. https://youtu.be/snw6gpWYuTc
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
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
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
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
SAP HANA connector in Power BI is available in two modes - Multidimensional and Relational. Let's look at the Pros and Cons of both these modes. Pros of Multidimensional Mode: Performance is good. Can connect to multiple data sources in Import mode. Parent child hierarchy is supported. SSL is supported. Cons of Multidimensional Mode: Composite … Continue reading SAP HANA Connector – Multidimensional or Relational mode
The experience while authoring reports using direct query for SAP data source is sometimes not optimal. Every click sends a query to the data source and we have to wait for the visuals to refresh.... Here is how I work around this issue. It's not ideal but makes authoring experience a little better. From the … Continue reading Improving authoring experience for SAP Direct Query reports