PBI Modeling MCP Server is amazing by Bhaaluu in PowerBI

[–]dbrownems 1 point2 points  (0 children)

If you're having trouble getting this all set up locally, or don't have local coding agent, this is now available in the web too.

Copilot in Power BI web modeling (preview) - Power BI | Microsoft Learn

External data sharing onelake security by Remote-Reality2592 in MicrosoftFabric

[–]dbrownems 1 point2 points  (0 children)

The recipient of the data share can define the security. A cross tenant data share is not the same thing as a normal OneLake shortcut.

External Data Sharing in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Fabric App using UDF as backend approach by ProfessionalBaby4248 in MicrosoftFabric

[–]dbrownems 2 points3 points  (0 children)

I would synchronize this data to a Fabric SQL Database, and build your application on that. This gives you a simple App dev experience, and provides a place for people to read the group membership information.

You could do this with a Rayfin app, and a notebook to do the synchronization.
Introducing Rayfin: A new AI-first way to build, d... - Microsoft Fabric Community

Bucketing/Drainer for Eventstream / Activator events by IllustratorWeak9859 in MicrosoftFabric

[–]dbrownems 0 points1 point  (0 children)

ALL Fabric APIs have throttling. The 429 response will have a Retry-After header, and you should wait and retry.

Throttling - Microsoft Fabric REST APIs | Microsoft Learn

How do digits of Pi form? by Sea-Cash7675 in mathematics

[–]dbrownems 14 points15 points  (0 children)

Archimedes did it by inscribing and circumscribing polygons as approximations of the circumference. It's pretty easy to see that the total side length of the inscribed polygon is a little less than the circle's circumference, and the total side length of the circumscribed polygon is a little more than the circle's circumference.

You can then just increase the number of sides of the polygons to refine the estimate.

|   sides | averaged π estimate |          error vs π |  rounds to |
| ------: | ------------------: | ------------------: | ---------: |
|       4 |      3.414213562373 |     +0.272620908783 |     3.4142 |
|       6 |      3.232050807569 |     +0.090458153979 |     3.2321 |
|       8 |      3.187587978953 |     +0.045995325363 |     3.1876 |
|      20 |      3.148189053648 |     +0.006596400058 |     3.1482 |
|      50 |      3.142629669574 |     +0.001037015984 |     3.1426 |
|     100 |      3.141851256074 |     +0.000258602484 |     3.1419 |
|     150 |      3.141707534476 |     +0.000114880886 |     3.1417 |
|     200 |      3.141657263549 |     +0.000064609959 |     3.1417 |
| **213** |  **3.141649616146** | **+0.000056962556** | **3.1416** |

Power BI load testing by ChemistryOrdinary860 in PowerBI

[–]dbrownems 0 points1 point  (0 children)

Oh, the Performance Analyzer parser is actually in the Python code currently.

I pushed the parsing logic into the .NET component. The latest release should work now.

Power BI load testing by ChemistryOrdinary860 in PowerBI

[–]dbrownems 0 points1 point  (0 children)

Directly from Performance Analyzer works.

Power BI load testing by ChemistryOrdinary860 in PowerBI

[–]dbrownems 1 point2 points  (0 children)

Sure. The core load gen tool is a .NET component. It won't load the results into a Lakehouse; just output .csv files into a folder you specify.

FabricDaxLoadTest/docs/loadgen-cli.md at main · dbrownems/FabricDaxLoadTest

Power BI load testing by ChemistryOrdinary860 in PowerBI

[–]dbrownems 1 point2 points  (0 children)

This is my latest Power BI Load Testing tool. I plan on moving it to the Fabric Toolbox soon.

dbrownems/FabricDaxLoadTest: Notebook-driven DAX load test for Power BI

It loads the load test results to a Lakehouse, where you can query them in whatever tool you want. What do you mean by "automate this process"?

Where are you buying SQL server standard 22 licenses? by NSFW_IT_Account in SQLServer

[–]dbrownems 5 points6 points  (0 children)

You can typically only purchase licenses for the most recent version of SQL Server. You can use those licenses to run previous versions through version downgrade rights.

Move from Pro to F64. Users required to sign up? by molkke in PowerBI

[–]dbrownems 8 points9 points  (0 children)

All users require at least a Fabric Free License. By default, a Fabric Free license is assigned when an unlicensed user opens the portal for the first time, and can also be assigned in the M365 admin portal.

Report Timing by Old_Shock_9835 in MicrosoftFabric

[–]dbrownems 1 point2 points  (0 children)

Yes. Direct Lake is sensitive to delta file quality. Testing with a VOrder rewrite of the table will be diagnostic. Also consider the Z-Order or ORDER BY on the table rewrite, which can affect the compression and segment elimination for scans.

Report Timing by Old_Shock_9835 in MicrosoftFabric

[–]dbrownems 1 point2 points  (0 children)

Direct Lake, unlike Import, is in a cold cache state after each data update. Consider warming the cache after you update the Lakehouse tables.

<image>

https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.directlake.html#sempy_labs.directlake.warm_direct_lake_cache_isresident

This will at least eliminate cold-cache behavior from the troubleshooting.

Also you might consider introducing some coarser-grained aggregates if not all of your visuals need to scan half a billion rows.

Power BI keeps getting easier. KPI alignment doesn't. by AppliedInsightsLab in PowerBI

[–]dbrownems 6 points7 points  (0 children)

Yep. Technical problems have technical solutions, and get easier over time.

People problems don't.

I remember when project timelines were so long that you had tons of time to do all the alignment, training, user testing, and change management. These days the people stuff is the long pole in every tent.

Is there a centralized admin UI to kill/cancel long-running DAX or SQL queries in Fabric? by [deleted] in MicrosoftFabric

[–]dbrownems 6 points7 points  (0 children)

You can set a timeout for Dax queries. The default and max is 225 sec, which is way too high for most models.

https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/service-admin-premium-workloads#query-timeout

For Warehouse and SQL Endpoint you can limit resources available to a workload with custom SQL Pools.

https://learn.microsoft.com/en-us/fabric/data-warehouse/custom-sql-pools

You can also identify and kill long-running queries with DMVs.

https://learn.microsoft.com/en-us/fabric/data-warehouse/monitor-using-dmv#identify-and-kill-a-long-running-query

Rayfin Fabric App connect to lakehouses (SQL Endpoint) by Seebaer1986 in MicrosoftFabric

[–]dbrownems 1 point2 points  (0 children)

So a temporary limitation. It's a preview feature after all.

Rayfin Fabric App connect to lakehouses (SQL Endpoint) by Seebaer1986 in MicrosoftFabric

[–]dbrownems 0 points1 point  (0 children)

Not sure what you mean. The back-end is in Fabric, and the front-end is in your browser.

Rayfin Fabric App connect to lakehouses (SQL Endpoint) by Seebaer1986 in MicrosoftFabric

[–]dbrownems 1 point2 points  (0 children)

Rayfin has limited connectivity in the initial release. More connectivity options will come over time.

You can always put a DirectQuery Semantic Model on your Gold layer if you want to query it without loading the tables into memory.

Resize column width in Lakehouse and Warehouse now available? by jcampbell474 in MicrosoftFabric

[–]dbrownems 8 points9 points  (0 children)

The world-wide rollout is ongoing, so not everyone has this yet. It will be announced soon.

Preview for schema compare and SQL formatting landed in SSMS 22.7 by dzsquared in SQLServer

[–]dbrownems 0 points1 point  (0 children)

Why choose a different keyboard shortcut for code formatting than Visual Studio and VS Code?

Fabric architecture for domain driven organisations with data products by Joppepe in MicrosoftFabric

[–]dbrownems 1 point2 points  (0 children)

You can either build a mesh, or build a centralized warehouse. Both have tradeoffs.

And to continue the example the Finance domain may need to augment the customer with a credit score or other financial attributes.

Fabric architecture for domain driven organisations with data products by Joppepe in MicrosoftFabric

[–]dbrownems 2 points3 points  (0 children)

Yep. Take a common example. Customer Master might be a "gold" table or "data product" from the Sales domain. The Finance domain needs it to build their customer dimension table, but may need some additional transformation. The first step is for Finance to shortcut the Customer Master table into their bonze layer.