User Profile

ati_puri

Resolver III

Joined 1 year ago

64 Posts33 LikesLikes received16 Solutions

View All Badges

User Widgets

Contributions

Access issues for Power BI Admin APIs
HI, I am accessing Power BI Admin APIs to fetch user/semantic models and capacities details etc, However, when we run those APIs in our notebook, I get this error PowerBINotAuthorizedException . This requires some tenant settings in Power BI Service API permissions for our SPN, but it does not work. The settings look like this below: Please let us know the exact setting to use Power BI APIs. Thanks Ati Puri
Solved
24 days ago Place Data Engineering
Data Engineering
266Views
0likes
4Comments
Re: Dataflow Gen2 cannot write to Fabric SQL Database, error says "Data source kind: FabricSql"
Hi tpg0220 , 1) There seems to no official documentation on the above issue from Microsoft, however, as Fabric SQL DB is authenticated via only OAuth2 and no SPN or workspace identity is supported, hence can cause cross-workspace conenction issue. You can raise a ticket for this bug to Microsoft once. Workaround- you can try using Azure SQL DB as your destination and give Fabric SQL DB endpoint -server name and database name. Use Fabric SQL DB T-SQL connection string. You can find it in settings-Connection strings-SQL server format. Authenticate it via Org account or SPN. This method bypasses FabricSQL connection. Let me know if the above solution works, else we can use Lakehouse to move the data to Fabric SQL DB. Let me know if it answers above query. Thanks Ati Puri
1 month ago Place Data Engineering
474Views
0likes
0Comments
Re: Fabric notebook Py4JJavaError - underlying location does not exist
Hi bekkac579 , The failure happens only when run via pipeline states that its a SQL Analytics endpoint metadata sync issue. You can add a refresh Sql endpoint activity before calling this code in your pipeline and try once, else you can refresh the query within the code itself. Write a sample warm-up query to activate your SQL endpoint before hitting the actual table and querying it. Refer link here to understand on this issue - SQL Analytics Endpoint Metadata Sync - Microsoft Fabric | Microsoft Learn Let me know if the above solution works. Thanks Ati Puri
1 month ago Place Data Engineering
218Views
0likes
1Comment
Re: Power BI - Fabric Capacity Metrics
HI girishtharwani2 , Capacity metrics app currently only shows GB consumption at workspace level and not item level. However, there is a way to check that in workspace settings. Check Onelake storage in workspace settings to get the storage details. This feature is in preview mode as of now. To know more about onelake storage - check this link - OneLake consumption - Microsoft Fabric | Microsoft Learn Let me know if it helps. Thanks Ati Puri
1 month ago Place Data Engineering
748Views
0likes
0Comments
Re: Hi everyone, how are you?
HI MXTP , Apart from MS Fabric, you can learn MS Azure, this will give you basic understanding of Cloud and Data Fundamentals and then go ahead with Data Engineering concepts. For eg: you can give AZ900 - Azure Fundamentals, DP-900, Azure Data Fundamentals and then DP203- Data Engineering certifications to gain more confidence. Also, learn SQL or Pyspark to gain coding knowledge. After this, you can get an idea on how Pwer BI reporting and dashboards work on the engineered data by doing some Power BI Certifications. DP600 also covers Power Bi concepts. Let me know if this information is helpful. Thanks Ati Puri
1 month ago Place Data Engineering
541Views
1like
0Comments
Re: got below error when i tried migrate pipelines with power shell module
Yes, UI does support and Power shell does not, however, Power Shell is recomended to use when we need to migrate in bulk or scripted migration or in soem CICD scenarios. As quoted my MSFT in their article- Power Shell migration makes sense when: 1) You want to script it(CSV/JSON) once and run overnight, UI will be manual. 2) The script can be parameterized for bulk loads. 3) For the smaller number of files, use migration assistants for the unsupproted file formats and when we have large number of files, we can use the hybrid approach of using Power shell for supported formats to load in bulk and the unsupported(Parquet/Avro) ones by UI. Let me know if the above response gives you more insights on your query. Please give Kudos if you like the response and mark it as solution if it solves your query/problem. Thanks Ati Puri
2 months ago Place Data Engineering
374Views
2likes
0Comments
Re: got below error when i tried migrate pipelines with power shell module
Hi dataengineerv2 , Check this link to understand what all datasets are supported for migration through PowerShell. - PowerShell Migration of Azure Data Factory and Synapse Pipelines to Fabric - Microsoft Fabric | Microsoft Learn I guess Parquet format is not supported and hence its a limiation from MS side. Thanks Ati Puri
2 months ago Place Data Engineering
425Views
2likes
2Comments
Re: Pipeline Schedule Parameters failing to run immediately.
Hi jisaac , Did you try manually fixing the json file a syou have GIT enabled? you can try fixing in GIT and sync it back to Fabric workspace. You can also try using Fabric REST API to create pipeline schedules. The solution to above question is also referred in an another community post, pls check this link, if its helpful for you.Solved: Re: Set parameter for scheduled run - Microsoft Fabric Community If you like my response, please give Kudos and mark my answer as a solution if it helped in any way. Thanks Ati Puri
2 months ago Place Pipelines
989Views
0likes
4Comments
Re: Fabric Runtime 2.0 with semantic link
HI benitovbreugel , If its urgent, you can still go back to Fabric runtime 1.3 to be compatible with Python version 3.10,<3.12 to make things work. Whenever there is new version available, you can anyday try with the new runtime. Thanks Ati Puri
2 months ago Place Data Engineering
500Views
0likes
1Comment
Re: Power BI - Fabric Capacity Metrics
Hi girishtharwani2 , Based on your screen shot i can understand you are seeing the storage details of the worksapces. There are few things we need to consider here while checking storage: 1) This is complete OneLake storage GB which is shown here based on the number of workspaces created. 2) The above information comes from STorage page, read the COMPUTE page to identify the Fabric items like warehouse/lakehouse/KQL DB/SQL DB CU consumptions, to identify the mroe usage. YOu can also check the othwr charts and graphs on the compute page to check how many reads/writes are happening in lakehouse/warehouse and in another storage. The item which consumes more CU's check if its a write operation, more writes means more table data is getting loaded. 3) Check notebook CUs on compute page, is there any notebook which writing into tables, thereby adding to more storage. The main idea is to check the compute page to identify usage of storage. Let me know if it helps, please give kudos if you like my response and consider it as a solution if it works for you. Thanks Ati Puri
2 months ago Place Data Engineering
945Views
1like
2Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.