We are continuing to make enhancements to our Coronavirus dashboard (https://bit.ly/2voUAbx ). We have added a new tab that allows us to analyze mortality rates by country and by number of infected per 1M of population. This tab has yielded some interesting insight. You can learn more about it as well as some of my
Lots of new features added to the dashboard.. also a video has been posted for those who need help with how to use it. Link to dashboard: https://bit.ly/2voUAbx Link to video: https://www.youtube.com/watch?v=T21h46ZDh14
Knowledgebank.pro has released a Power BI report with Coronavirus (COVID-19) statistics by Country/State. The data set is updated daily. You can find it following this link:
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
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
The full credit for this goes to the Guy in the Cube for his video where Adam talks about how to fix direct query to Azure Databricks models deployed to PowerBI.com . Unfortunately, this issue also affects import models as well. If you have an import model from Azure Databricks and you try to set
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
This post is a beginning to a series of articles about building analytical capabilities in Azure using data lake, Databricks and Power BI. On the surface, those technologies seem like they were specifically designed to complement each other as they provide a set of foundational capabilities necessary to develop scalable and cost-effective business intelligence
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
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
