Microsoft Data Platform News 2024 - Week 17

Content

Power BI

• GitHub repository of Power Query functions

Fabric

• QA in Fabric
• Edit Fabric Pipeline's JSON
• Refreshing Selected Tables in a model
• Exporting Power BI Reports And Sharing With Granular Access Control In Fabric
• Fabric and Self-Service: Control who can use

Power BI

GitHub repository of Power Query functions

Today, I want to share the GitHub repository where this library is located. Its goal is to become a must-import for every developer when starting a PowerBI project.

https://www.dhirubhai.net/posts/oscarmartinezv_powerquery-github-powerbi-ugcPost-7184227661857103872-pM6v?utm_source=share&utm_medium=member_android

Fabric

QA in Fabric

In this blog post, I'll share some of the key features that have caught my eye and explain how they can help you ensure your data is accurate, reliable, and consistent.

https://www.dhirubhai.net/pulse/qa-fabric-helena-balzerov%2525C3%2525A1-v9xne/?trackingId=mxqV7YubR%2ByJixj%2B48InRQ%3D%3D

Edit Fabric Pipeline's JSON

This article introduces the possibility of editing the JSON configurations of Fabric pipelines directly through the interface.

https://www.dhirubhai.net/pulse/edit-fabric-pipelines-json-dtower-software-ouzdf/?trackingId=3I2%2F2X3WTQKkYDxwSyPOiw%3D%3D

?

Refreshing Selected Tables in a model

Since version 0.4 Semantic Link there have been several methods to refresh individual tables and partitions in a semantic model. In this blog, I will show how to use the .refresh_dataset().execute_tmsl() and TOM to achieve granular refresh.

https://fabric.guru/refreshing-individual-tables-and-partitions-with-semantic-link#heading-method-3-using-tom-semantic-link-vgt07

?

Exporting Power BI Reports And Sharing With Granular Access Control In Fabric

Using Semantic Link and data access control to export & distribute Power BI report PDF extracts securely

https://fabric.guru/exporting-power-bi-reports-and-sharing-with-granular-access-control-in-fabric

?

Fabric and Self-Service: Control who can use

Using Fabric Admin Portal you can control who will have access to create Fabric objects.

https://www.red-gate.com/simple-talk/blogs/fabric-and-self-service-control-who-can-use/

Luká? Karlovsky

Power BI | FABRIC | Power Query | SQL | Data | DWH | Excel | VBA | Instructor

LinkedIn Profile

Joyful Craftsmen

Joyful Craftsmen is a data design and data engineering team. We’ve been learning and building data solutions since 2014. We focus on our vision to do the data craft as smartly as reachable. Humanity, teamwork and joy is part of our game, regardless you are our partner or one of us. Altogether we are valued for delivering cutting edge data solutions, on time, in top quality.

https://joyfulcraftsmen.com

https://www.dhirubhai.net/company/joyful-craftsmen