Welcome back to another installment of our Reporting Tuesday blog posts. In this article, we will delve into the fundamental Data Transformation Techniques in Power BI. This exciting journey will enable you to harness Power BI's capabilities to transform and visualize your data effectively. To create powerful and insightful reports and dashboards, you often need to clean and shape your data to make it suitable for analysis. In this piece, we will explore some essential data transformation techniques in Power BI to help you get started on this enriching journey. Enjoy!
5 min read
Basic Data Transformation Techniques in Power BI
By Mads Bender on 26 September 2023
Topics: PowerBI Reporting tuesdays
2 min read
A quick introduction to Microsoft Fabric
By Mads Bender on 27 June 2023
Welcome back to a new Reporting Tuesday blog post, where we explore Microsoft Fabric—a platform that has the potential to take your data processing to the next level.
Topics: D365FO PowerBI Fabric
4 min read
Exploring the Key Influencers visual
By Mads Bender on 30 May 2023
Welcome back to a new Reporting Tuesday blog post, in this post we will explore the Key Influencers visual. This is exciting because it allows you to rapidly find statistical trends in your data. Enjoy!
Topics: D365FO PowerBI
3 min read
Introduction to Smart Narrative in Power BI
By Mads Bender on 16 May 2023
Welcome back to a new Reporting Tuesday blog post, in this post we will explore Smart Narrative in Power BI. This is exciting because Smart Narrative provides a quick interpretation of your data that you can share with others. It can help you make sense of complex information and explain it in a way that everyone can understand. Enjoy!
Topics: D365FO PowerBI
4 min read
Create a Navigation/Filter bar in Power BI
By Mads Bender on 02 May 2023
Welcome back to a new Reporting Tuesday blog post, in this post we will explore how to create a navigation bar in Power BI. This is exciting because it allows you to add user interface to your reports without losing reporting area. Enjoy!
Topics: D365FO PowerBI
6 min read
Combine multiple web sources to one dataset
By Mads Bender on 18 April 2023
Welcome back to a new Reporting Tuesday blog post, in this post we will explore how to combine multiple web sources to one dataset in Power query. This is exciting because it allows you to mark comprehensive datasets using web sources. Enjoy!
In this blog post we are going to look at how to make a dataset in excel power query that combines data from multiple web sources. For this specifically we will look at how to get data from several stocks into excel and return it to one table.
Here when we talk about a web source, we refer to a source of data that can be accessed over the internet using a web browser or a programming language. Web sources can include websites, databases, and other online resources that provide data in a structured format, such as HTML, XML, or JSON. For this we will make a list of stocks to track and retrieve the data from yahoo finance.
First, we need to open a new excel document, and make a table with the following column headers: Ticker name, From, To, Interval, URL_hist, URL_summary and months of data. These will be used to collect data, and with proper setup you only need to fill in the ticker and the rest is done by formulars.
This is how we will fill in the table:
Topics: D365FO PowerBI
5 min read
Create buttons in Power BI
By Mads Bender on 21 March 2023
Welcome back to a new Reporting Tuesday blog post, in this post we will explore the creation of buttons in Power BI. This is exciting because buttons make your Power BI reports more interactive and give your users more control over what they see. Enjoy!
Topics: D365FO PowerBI
5 min read
Working with bookmarks in Power BI
By Mads Bender on 07 March 2023
Welcome back to a new Reporting Tuesday blog post, in this post we will explore bookmarks in Power BI. This is exciting because bookmarks are a great way to quickly access different parts or views of a report in Power BI. They can save you a lot of time and make it easier to explore and understand your data. Enjoy!
Topics: D365FO PowerBI
6 min read
Power BI web sources Part 3 – Partner API and python
By Mads Bender on 21 February 2023
For this third part of Power BI Web sources, we will explore the use of Partner API in Power BI. This can be done in multiple ways;however, you must add code to your solution. Since, this relies on code no matter what I want to take this opportunity to combine Power BI with python query. Doing this demands that you have a python client installed on the computer and that you have installed the libraries Requests and Pandas.
Topics: PowerBI
3 min read
Power BI web sources Part 2 – API
By Mads Bender on 07 February 2023
In the first part we looked at how to extract Stock data for Microsoft using Yahoo Finance. Yahoo Finance used to have their own API, today you can find third party APIs. However, because I want to go into the logic of an API, we will change to a different data set. First, we will look at covid tracking, that is an opensource dataset, and the process is exactly as we saw it from yahoo finance.
Topics: D365FO PowerBI
Posts by Tag
- D365FO (49)
- Finance (27)
- PowerBI (14)
- Insider (8)
- Reporting tuesdays (5)
- D365 Supply Chain Management (3)
- AI (2)
- BPA (2)
- Business Performance Analytics (2)
- Retail (2)
- Workspace (2)
- ALM (1)
- Artificial intelligent (1)
- Azure (1)
- D365 Commerce (1)
- DynamicsCon (1)
- Fabric (1)
- Machine learning (1)
- RSAT (1)
- Workflows (1)