In the realm of Power BI Dataflow, we're accustomed to the richness of functionality and the ease with which these functionalities can transform data. But what about Copilot? Can it help us navigate complex operations such as append, merge, pivot, unpivot, and group by? While we may not need assistance with basic operations like filtering … Continue reading Exploring Copilot’s Role in Dataflow: A Dive into its Functionality
Category: Power Query
Power BI: Tips and Tricks for Building Professional Power BI Model (and a star schema tutorial)
If you are relative beginner in Power BI / Business Intelligence, you will definitely benefit from this lab/tutorial. First, I go over the best practices with respect to designing your data model. I define dimensions and facts and why not thinking about the layout of your data leads to really bad model designs. After theory, … Continue reading Power BI: Tips and Tricks for Building Professional Power BI Model (and a star schema tutorial)
How to Switch Your Power BI Table to a Different Data Source Type Without Breaking Anything
If your model started out in Excel, but now you are forced to connect to data in a database, you do not have to stress out. Yes, unless you watch this video, you will have to rebuild everything, but if you do watch this video, I will show you how you can move your table(s) … Continue reading How to Switch Your Power BI Table to a Different Data Source Type Without Breaking Anything
Power Query – Merge Function
Can I use merge function to filter data ? Yes you can and there are gotchas... Listen to the post for details: https://www.youtube.com/watch?v=ycb4qzo0nhE&t=128s
Power Query – Create Functions
How hard is it to create functions in Power Query ? Do I need to learn coding to write functions ? When should I create functions ? I answer these questions in the following post: https://youtu.be/XGlTcgELxG4
Power BI: Control Dataset Size Using Parameters
In this post, I cover the steps to use parameters to control dataset size. Check it out. https://www.youtube.com/watch?v=7ipslDgCtss&feature=youtu.be
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
Quirks of Visual Studio Query Editor working with Analysis Services
Visual Studio 2017 and the SQL Server Data Tool (SSDT), a tool that comes with Visual Studio, finally integrates the now familiar Query Editor (Power Query) capability to work with the Analysis Services Tabular Model. Query Editor is a data ingestion and transformation tool used by Excel Power Pivot as well as Power BI. Now, … Continue reading Quirks of Visual Studio Query Editor working with Analysis Services
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
How to Expose Key Values from SAP BW in Power Query
This information has been around the blogosphere for a while but I keep forgetting how to find it; I decided to write about it on my blog so that I can easily find it next time I need it. The existing functionality of the Power BI Connector for SAP BW only exposes text values of … Continue reading How to Expose Key Values from SAP BW in Power Query
business intelligist 