Microsoft Fabric provides various options for data ingestion, each with its own strengths and use cases. Understanding which option to use and when can significantly impact your data workflow efficiency. In this video, we'll explore the different data ingestion methods offered by Microsoft Fabric—Dataflow (with and without Fast Copy), Data Pipeline, and Notebooks—and discuss their … Continue reading Choosing the Right Data Ingestion Method with Microsoft Fabric
Category: This and That
Data Mirroring – Real-Time data replication
We have all heard of Real-Time solutions before. But each of them come with challenges. Either configuration is complicated or involves coding/ETL or the cost is exorbitant. Data Mirroring in Microsoft Fabric is none of the above. It is easy to configure, involves no ETL and the cost is minimal. This feature is in public … Continue reading Data Mirroring – Real-Time data replication
Visual Calculations – Update Your PBI Desktop Now!
Looks like the Power BI team might've dropped the Feb 2024 Desktop version a bit early. And you know what? I'm not mad at all. It's got this feature I've been waiting for forever: Visual Calculations. Now, you can add measures right where you need them, without making a mess of your semantic models with … Continue reading Visual Calculations – Update Your PBI Desktop Now!
Reboot and Restart
I know it's been a hot while since we have posted anything new on this platform and I am sorry. Life got too busy plus I was starting to feel that this blog was really not adding anything incremental to what was already happening in the Power BI / Microsoft Analytics blogosphere. Afterall, tons of new … Continue reading Reboot and Restart
KNOWLEDGEBANK.PRO VLOG #2: Channel Update, Two Custom Visual Reviews and a Bit of Ranting
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
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