BI Summit

If you work with Microsoft Fabric Lakehouses , you know the story all too well: You load data, transform it, optimize it… and then you still...

I was think few days back about how BI could work with Stock Prediction. To do it first I needed regular stock price data from the interne...

Error: SQL SPLoadxxx:Error: Executing the query "EXEC SPLoadxxx ?" failed with the following error: "Multiple-step OLE DB o...

Issue is where your table in the model diagram has both Measure and Attributes and you add a new column to the table in model diagram. Aft...

Recently I wanted to create a StoredProcedure to convert all the views which read millions of records to tables in a database. The Reason...

In the last post I showed you know to build a Parent-Child Hierarchy. This time we implement the same Parent-Child Hierarchy in a different...

Building a Parent Child Hierarchy looks complicated but is easy if all the rules are followed correctly. I will here list down few steps wh...