Steps: Download and install ODAC OUI from Oracle website . Don’t install the XPath installer. Use the OUI installer. Also, make sure the ODAC version (32/64 bit) matches with your Power BI Desktop version. 2. Register ODP.NET Unmanaged client to GAC by running the following commands in CMD. Make sure you start the CMD in … More Oracle Wallet based connection with Power BI
Azure Analysis Service Replicas Azure Analysis Service lets you scale out your queries very easily through replicas. Replicas are nothing but multiple copies of your Azure Analysis Service (AAS) database. In critical times, queries can run in replicas and reduce the load on Query Processing Unit (QPU). You can read more about Analysis Service replicas … More Sync Azure Analysis Service Replicas with Azure Automation
Ever faced the following error while changing any properties in Azure Analysis Service or while processing a Analysis Service Database: “ This operation is not allowed by The Azure Analysis Service product as the current context is read-only” All you have to do is to add “:rw” at the end of your server name URL … More Azure Analysis Service – current context is read-only
MongoDB server and clients – at a glance. Useful for beginners:
Welcome back 🙂 It’s time to talk about one of the most ‘famous’ issues of Power BI. It appears when you have parent-child or cascading slicers in your report. Let’s say, you have a parent slicer ‘Category’ and a child slicer ‘Sub-Category’. When you change a selection in Parent, child selector doesn’t change to any … More Cascading or parent-child slicer issue in Power BI
Let’s get straight into the problems. Problem #1 You get country sales data on monthly basis. But, some of the countries i.e. Switzerland and Italy lag the others. Let’s imagine a scenario when all countries latest data (June-2020) has arrived except Switzerland and Italy. This is how your data table would look like in this … More Finding common maximum in Power BI
This is just a compilation of different types of linking mechanisms in Power BI. I have explained them from use case point of view. It’s mainly written for newbies like me who are wondering which linking feature is applicable for which use case? 🙂 Tiles: Link between dashboard and reportss This is only available for … More Links in Power BI
I have found many articles on web regarding non-additive measures in power BI. But most of them are about inventory-type measures where normal aggregate functions are not suitable for use. However, in real life we often face situations where data providers deliver pre-calculated measures for different hierarchy levels. Numeric distribution, weighted distribution, market share etc. … More Non-additive measures with different granularity in Power BI
You need to create a SQL Server credential first to restore a database back up from Azure blob storage. A lot of writings can be found around the web on this. Most of them have used Azure Storage Account to create the credential in the first place. In this short post, I will be using … More Restore SQL Server database using SAS from Azure Blob Storage
Sometimes you may need to set device specific logic in your microstrategy documents or reports. For example, some VI charts show different labels or different headers for iPad and you may want to hide them in iPad using a rectangular label. Or, you may not want to allow iPad users to click a certain button … More Device specific logic in Microstrategy
Zahid's blog on Data Engineering and BI 