MS Fabric Analytics Engineering plus Power BI topics
-
A BI Developer’s First Look at dbt labs: Why I’m a Believer
As part of my journey to become a Microsoft Fabric Analytics Engineer, I recently completed the dbt fundamentals with VSCode course. I am new to the tool but I am really impressed. In my 8 years of BI experience I saw a lot of data quality and maintenance scenarios where dbt can help out with.…
-
Maximize Your Report Canvas: Use hidden slicer panels in reports!
If you have a lot of slicers then you are going to have a lot of pages, this method can save space on each page. It has some disadvantages, since the slicers are hidden, the only way to show filters are either building dynamic titles or hovering over the filter icon of a visual. It's…
-
Read this if you are Vibe coding with MS Fabric!
Today using AI for supporting development is expected but copy pasting code for AI can bring dangers as well. It's a basic requirement for all developers to protect all sensitive information from accidentally sharing sensitive information with AI when we are asking it to help out with a coding problem. I have vibe coded multiple…
-
An Inspiring Experience at FabCon Vienna!
I feel inspired to research all the features I haven't explored yet.I was so happy to share this amazing experience with my colleague and team member, Viviane Azevedo.I started learning Power BI in 2017 and learned most of what I know from the Microsoft Data community, which is why I truly appreciate people sharing their…
-
How to Create Your Own Microsoft Fabric Sandbox Environment
Have you ever wanted to test a new Fabric feature but didn't have the admin rights on your company's tenant? Or perhaps you're preparing for a new Fabric role and need a personal environment to build, learn, and experiment without restrictions. I have used my study tenant so many times in the past few years…
-
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…
-
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 class on 2022-10-14.organized by the MOME university. I gave a lecture in this building, I was glad that this year the university decided to have this course as an in-person type compared to teaching via MS Teams as we did…
about me
My name is Bertalan Rónai.
Hi...
My name is Bertalan Rónai. I have been working with MS BI tech stack since 2017 and currently I am passionate about becoming a MS Fabric Analytics Engineer. Contact me on LinkedIn if you want to help me reaching this goal.