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
Category: This and That
KnowledgeBank VLOG #1: Intros, goals and some background on what we want to do…
I decided to record a quick video on what the KnowledgeBank is, what we are trying to do and why we are doing it. No point to rehashing it here as it's a short video, hope you like what I got to say. https://youtu.be/0sL8t4hl9_E
My Reaction to Microsoft Closing its Retail Stores
Microsoft just recently announced that it is taking a "new approach to retail". What's the new approach you ask??? Well, it is a bit unorthodox. The new approach to retail is to have no retail. This is a bit of a sad news for me as I do a lot of work with Microsoft and … Continue reading My Reaction to Microsoft Closing its Retail Stores
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
Improving authoring experience for SAP Direct Query reports
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
How to overcome SAP BW memory overflow issue
I have been using Power BI BW connector to connect to composite provider and BEx query for a while now. I have run into issues where there is a memory overflow in SAP BW or time out error quiet often. This is typically due to the volume of data that needs to be retrieved. Here … Continue reading How to overcome SAP BW memory overflow issue
Scheduling Power BI Data Refresh using APIs
We have an enterprise job scheduler which is used to execute ETL jobs. The last step of the job scheduler is to refresh the Power BI data set. Here are the steps to do it. Create a Service account in your Azure Active Directory. Assign Pro license to the Service Account. Add the Service Account … Continue reading Scheduling Power BI Data Refresh using APIs
SAP BW Connector for Power BI – Support for additional member properties
October update of Power BI Desktop was released a couple of days ago. One of the key feature update in this release is that the SAP BW Connector now supports additional member properties (attributes). Earlier version of SAP Connector exposed only text value of the BW object. To get additional member properties, we had to have … Continue reading SAP BW Connector for Power BI – Support for additional member properties
SAP BW Connector for Power BI – Entering Parameter values
With recent updates to Power BI Desktop there have been a lot of enhancements to BW connector. The most significant of them is the ability to filter parameters to display only those that are required. This is achieved by clicking on Show on the top right corner of the Navigator dialog and selecting Only required parameters. … Continue reading SAP BW Connector for Power BI – Entering Parameter values
Scaling Azure Data Warehouse using Azure WebJobs Scheduler
Following link looks into various options available to scale compute power in Azure SQL Data Warehouse. Next question that one would ask is, how do I automate the capability to scale the compute power. In this article, I answer the question using Azure WebJobs. Azure WebJobs provide an easy way to run scripts or programs … Continue reading Scaling Azure Data Warehouse using Azure WebJobs Scheduler
business intelligist 