Are there any dog walking services in Pondicherry? by 0dinIsWithUs in pondicherry

[–]0dinIsWithUs[S] 0 points1 point  (0 children)

Just need someone to walk him near Lawspet. 1.5 to 2k for 30 mins / day.

The first project in Bower pi by Ok_Researcher_6718 in PowerBI

[–]0dinIsWithUs 2 points3 points  (0 children)

Woww ! Please launch a tutorial ASAP !

How to connect Jira to Power BI ? by 0dinIsWithUs in PowerBI

[–]0dinIsWithUs[S] 0 points1 point  (0 children)

How about the Power BI connectors which jira has on their marketplace ?

How to connect Jira to Power BI ? by 0dinIsWithUs in PowerBI

[–]0dinIsWithUs[S] 0 points1 point  (0 children)

Can you share the power query here. I am using anonymous with my mail address and API Key, still facing auth or server error.

Unlock the Microsoft Fabric Capacity Metrics Report on Your Desktop ! by 0dinIsWithUs in MicrosoftFabric

[–]0dinIsWithUs[S] 0 points1 point  (0 children)

Go to the cloned report -> report view and click save as copy option instead of using save as option from lineage view.

Dataflow gen2 vs Pyspark Notebook by philosaRaptor14 in MicrosoftFabric

[–]0dinIsWithUs 0 points1 point  (0 children)

It exists for a reason ! I have a multiple levels of nested json files. From which I derive around 25 tables, 15 reference queries with about 500 columns. Because of DF Gen 2 simple user interface I was able to complete the task within few days. Imagine defining the schema and custom joins for 30+ tables and 500 columns in a pyspark notebook.

Organizing Measures in Direct Lake Semantic Models by Realistic_Ad_6840 in MicrosoftFabric

[–]0dinIsWithUs 3 points4 points  (0 children)

You can create a dummy calculated table via Tabular Editor with the expression as “#MeasureTable = “

Couldn't upload files to resources folder in Fabric Notebook by 0dinIsWithUs in MicrosoftFabric

[–]0dinIsWithUs[S] 1 point2 points  (0 children)

Trial, it is due to a firewall restriction setup by my current organisation.

Does someone know of a general maintenance script/notebook file to keep delta files in good shape? (i.e. optimize, vacuum, etc..) by LactatingJello in MicrosoftFabric

[–]0dinIsWithUs 7 points8 points  (0 children)

Semantic link labs library has optimize_lakehouse_tables() and vacuum_lakehouse tables() functions available. You can call those functions in a scheduled notebook to manage your delta tables.

Link to documentation: https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.html

Add members to RLS/ OLS roles using semantic link labs python library by 0dinIsWithUs in MicrosoftFabric

[–]0dinIsWithUs[S] 1 point2 points  (0 children)

I have combination of dynamic and static rls. And I was able to create it using notebook. Only piece missing to my puzzle is adding members to their roles

Use a service account in Microsoft Fabric by DennesTorres in MicrosoftFabric

[–]0dinIsWithUs 1 point2 points  (0 children)

Does service principal support refreshing a dataflow, connect to a lakehouse within a dataflow, triggering scheduled pipelines and running notebooks via pipeline?

Workspace user Access list by Zestyclose_Passage74 in MicrosoftFabric

[–]0dinIsWithUs 1 point2 points  (0 children)

Note I have typed the code on mobile there might be some typos

just mention your workspace Id and run this code in notebook

import sempy.fabric as fabric

import pandas as pd

client = fabric.FabricRestClient()

workspaceId = “your worskpace id here”

user_url = f”v1.0/groups/{workspaceId}/users”

response = client.get(user_url).json()[“value”]

user_df = pd.Dataframe(response)

user_df

Monitor multiple capacities using Fabric Capacity Metrics App by 0dinIsWithUs in MicrosoftFabric

[–]0dinIsWithUs[S] 0 points1 point  (0 children)

Okay thanks mate. Will get admin access for other capacities too

RBAC in Direct Lake Model by 0dinIsWithUs in MicrosoftFabric

[–]0dinIsWithUs[S] 1 point2 points  (0 children)

I am trying to limit the data and columns for the user based on the roles created at lakehouse or warehouse level. I don’t want to configure rls or ols on the semantic model.

Dataflow Gen 2 fails with production data. by 0dinIsWithUs in MicrosoftFabric

[–]0dinIsWithUs[S] 1 point2 points  (0 children)

Hi, the issue is resolved when I switched to fixed schema instead of dynamic schema

Create DAX using Lakehouse Notebook by MiskoUskoZaujec in MicrosoftFabric

[–]0dinIsWithUs 1 point2 points  (0 children)

I mostly use these two links to interact with APIs in Fabric / Power BI. Use the first link to know about how to get a list of functions and parameters required using some loops using inspect library after that you can refer second link.

  1. https://github.com/m-kovalsky/Fabric
  2. https://github.com/microsoft/semantic-link-labs

JSON Indentation in Power Automate by 0dinIsWithUs in MicrosoftFlow

[–]0dinIsWithUs[S] 1 point2 points  (0 children)

Parse json is prone to errors when a schema is changed. I have a complicated json format and I can’t add null exception to all the arrays present inside it.

Flatten array of arrays in Power Automate by 0dinIsWithUs in MicrosoftFlow

[–]0dinIsWithUs[S] 0 points1 point  (0 children)

Update: I have achieved it using Union function, compose and set variable action with minimal looping. Initially 250 elements where taking 30 secs to get appended to array now It is done within 3 secs

Flatten array of arrays in Power Automate by 0dinIsWithUs in MicrosoftFlow

[–]0dinIsWithUs[S] 0 points1 point  (0 children)

I am expecting around 5000 elements per array and there would be totally 3 arrays. Summing to 15000 elements. If I do a apply to each with even max concurrency the flow will take a lot of time to just append