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! 

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! 

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.

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. 

After loading data to Power BI, you have the option to transform the data, for some queries you might not use this at all and for other you might use it extensively. One of the things you can do here is to normalize a data source. You can duplicate a query and then remove redundant data to decrease the size of you report. It is also possible to add calculated columns, let say you have the value in local currency and the exchange rate to your reporting currency. Then you can make an extra column with the value in reporting currency.

Most people today know of or have heard of Power BI. Power BI is a simple software and with limited introduction you will be able to produce meaningful reports. It is then possible to dive deeper into the software and create very complex and beautiful reports, again with limited effort. This is one of the things I really enjoy with Power BI. It is an extremely powerful visualization tool.

Power BI is built up with a similar layout to Microsoft other products and when you open a power BI desktop session you will have the following 7 modules:

Power BI is one of the biggest and most popular BI tools today and it is a central part of many companies’ business intelligence toolbox. Therefore, it is essential to integrate your ERP solution with your Power BI. This post will explore the method for retrieving D365FO data from Azure Data Lake.