Bertalan Rónai
My blog about BI developer topics
-
I tried to finish my MS Fabric notebook with chat-gpt o3-mini
I saw some news about Chat-GPT and MS offering o3 models. I created a ChatGPT Plus subscription as I did not want to spend time researching provisioning the MS version. I wanted to find out if this model can help me perfect my newest MS Fabric Notebook. Have I told you that they started calling…
-
Fabric Use case : Triggered dataset refresh
This is just a very simple use case for a data pipeline. First you will need a table from data engineering that shows the last time a table or view had been updated, for example view_name, last_updated, report. Create a calculated column in a view that says that a given view belongs to a given…
-
I just came back from a BI conference in Wien.
Data Saturday #63 DATA COMMUNITY AUSTRIA DAY 2025 Last year I took the DP-600 exam because I wanted to prove that I am interested in Fabric and providing value to my team beyond current expectations. Preparing for the exam felt nostalgic as I took my last exam in 2020. The logic was similar, I attended…
-
The cold hard facts of using version control for Power BI
I spent a couple of weeks researching the topic of version control for Power BI. At the end of this article, I'll share a few links so that you can do the same and decide what's best for you and your team. The manual version control/backup strategy that most BI developers are doing is taking…
-
Document your reports from a Fabric notebook
By now you have heard about Fabric notebooks, the semantic link and the INFO functions in DAX. Let's combine them! Related links: https://data-marc.com/2021/02/18/trigger-a-single-table-to-refresh-in-the-power-bi-service/https://powerbi.microsoft.com/en-us/blog/dax-query-view-introduces-new-info-dax-functions/https://pbig.nl/media/jcxhj3tk/2024-03-09_exploring-semantic-link-for-power-bi-folks.pdfhttps://github.com/microsoft/fabric-samples/blob/main/docs-samples/data-science/semantic-link-samples/powerbi_measures_tutorial.ipynbhttps://learn.microsoft.com/en-us/fabric/data-science/tutorial-power-bi-measures My solution is building on this blogpost https://amalbenrebai.substack.com/p/544 fromAmal Ben Rebai. I added a few changes to the code in Amal's blog post, first I added the Displayfolder, then I filter out…
-
My trip to Lisbon in 2024 November
I had a wonderful time visiting Lisbon and my local team members this November. Beautiful city, friendly people, good food!
-
Trying to clear up BI role definitions
In the world of business intelligence, roles can vary significantly based on the size of the organization and the specific responsibilities assigned. Let’s explore two scenarios to illustrate these differences: Enterprise Ed works at a large corporation with a substantial IT team. He is working on a project to segment user data for the Marketing…
-
Hi, You! Do you want to guess the result of my Fabric exam?
We have to go back to 2017 first. I passed my first MS exam then, It was part of my development plan at the project company I worked for. Telling a junior to take a MS exam saves a lot of time as there is no need to allocate senior dev. time for mentoring or…
-
Fabric Use case : Sync dataflow and dataset refresh
Hi there, I can't believe that this is so easy!
-
Dynamic X,Y Axes for Power BI
Are you also using Parameter Fields to reduce the number of visuals?Would you like to use dynamic axis titles? You can have one column chart and you can select the measure or measures shown via a slicer. It can happen that you are analyzing quantity of items in your warehouse and the items have different…
-
JIRA Work logs from Tempo API into Power BI
I have been asked to look into the way of extracting the work logs from JIRA in a way that can be easily analyzed by BI tools such as Excel or Power BI. Work time logging is done by addons or apps created by vendors in JIRA. The way to extract data out of them…
-
Storytelling with Power BI in PowerPoint
There is a new feature that helps embedding live Power BI visuals and pages into a presentation. Imagine that you are presenting about your sales results by countries and a stakeholder asks a question about the distribution of sales within a country. You won't need to change tools to answer the question anymore.
-
Power BI – Class of Dashboards 2022
I gave a lecture about DAX, Power Query and tons of other topics for a classorganized by the MOME university. I gave a lecture on 2022-10-14 in this building, I was very glad that this year the university decided to have this course as an in-person type compared to teaching via MS Teams last year.…
about me
My name is Bertalan Rónai.
Hi...
My name is Bertalan Rónai. Hopefully I'll write great content about BI development topics.
