Power BI

Power BI

9059 bookmarks
Custom sorting
Power bi get data from multiple files in a folder on onedrive for business no gateway needed
Power bi get data from multiple files in a folder on onedrive for business no gateway needed
I have written another blog article previously about how to set up your Power BI to get data from a file in OneDrive for Business folder without needing gateway. That was a popular blog article, but I got questions about what if I want to get data from a folder in OneDrive for business but…
Power_BI_tips·radacad.com·
Power bi get data from multiple files in a folder on onedrive for business no gateway needed
Unfill in Power Query
Unfill in Power Query
Recently I received a question on how to Unfill in Power Query - remove all duplicate instances of a value, replacing them with null
Power_BI_tips·excelguru.ca·
Unfill in Power Query
Create Row Number for Each Group in Power BI using Power Query
Create Row Number for Each Group in Power BI using Power Query
If you want to create a row-number statically as a pre-calculation in Power BI, then Power Query has a very simple way of doing it; Add Index Column. However, the Index column creates the row number regardless of any grouping or categorization. sometimes you want to take that into account too. There is a little…
Power_BI_tips·radacad.com·
Create Row Number for Each Group in Power BI using Power Query
Get the List of FOLDERS only in Power BI using Power Query
Get the List of FOLDERS only in Power BI using Power Query
There are times that you need to get the list of FOLDERS and not just files. Of course folder itself (without considering files in it), doesn't contain data to be used for a report. However, sometimes, even the folder name might contain some useful information. The Get Data From Folder option in Power BI will…
Power_BI_tips·radacad.com·
Get the List of FOLDERS only in Power BI using Power Query
Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed
Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed
I have written another blog article previously about how to set up your Power BI to get data from a file in OneDrive for Business folder without needing gateway. That was a popular blog article, but I got questions about what if I want to get data from a folder in OneDrive for business but…
Power_BI_tips·flip.it·
Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed
All in One: Script to Create Date Dimension in Power BI using Power Query
All in One: Script to Create Date Dimension in Power BI using Power Query
I have written multiple blog posts about how to create a date dimension using Power Query, however, the purpose of those blog posts was to teach you how to do it yourself, learn the process and also build the date dimension that you can use. Sometimes, however, you just want to create a date dimension…
Power_BI_tips·radacad.com·
All in One: Script to Create Date Dimension in Power BI using Power Query
Convert flat list to table in power bi pivot without a set key column using power query
Convert flat list to table in power bi pivot without a set key column using power query
The scenario I am explaining today is a very specific use case, However, I have seen examples similar to this happens very often. It happens that you get a text or Excel file with values written in a flat list structure, and that needs to be changed to a table format. Usually, this process can…
Power_BI_tips·radacad.com·
Convert flat list to table in power bi pivot without a set key column using power query
Cartesian Product in Power Query: Multiply All Sets of All Pairs in Power BI
Cartesian Product in Power Query: Multiply All Sets of All Pairs in Power BI
Sometimes, you need to create a multiplication of all sets of all pairs from two different data tables in Power BI. This action is different from Merge (Join) because there is no matching key columns and no way to relate the two tables together. However, you want to create a multiplication as a flatten table.…
Power_BI_tips·radacad.com·
Cartesian Product in Power Query: Multiply All Sets of All Pairs in Power BI
Custom Aggregations in ‘Group By’
Custom Aggregations in ‘Group By’
Grouping Basics You can find the Group By button on the Power BI Query Editor window in 2 places: In the result dialog box, you can choose your key columns and aggregates. The key columns will default to what columns you currently have selected: From here, you will get the grouped result: Custom...
Power_BI_tips·community.powerbi.com·
Custom Aggregations in ‘Group By’
COVID-19: Build your own Power BI dashboard
COVID-19: Build your own Power BI dashboard
With all the craziness in our lives due to coronavirus, the reliance today on facts is more important than ever. To help you stay safe I thought you would appreciate this tutorial to learn how you can build your own reliable Power BI report that can analyze the confirmed infections, recovery and death rates of …
Power_BI_tips·flip.it·
COVID-19: Build your own Power BI dashboard