Questions tagged [microsoft-fabric]

22 questions
1
vote
1 answer

python import error in Microsoft fabric notebook

I was trying to import some langchain modules in a notebook in Microsoft Fabric like below. The notebook is using Python 3.10 Step 1: pip install langchain openai --> successful Step 2: from langchain.llms import OpenAI from langchain.llms import…
Andy
  • 405
  • 1
  • 5
  • 16
1
vote
1 answer

Fabric datafactory copy data to ingest Sharepoint files

I'm looking at MS Fabric to: Ingest data from multiple sources including xls / csv sharepoint online files and azure SQL databases. Store this data in onelake Use synapse (or a workflow in data factory) to process the various sources data into a…
1
vote
0 answers

Filter The Records In The PowerBI

I have three tables for the PowerBI report 'table1' Which is having below columns id1 name1 'table2' Which is having below columns id2 name2 'table3' which is having below columns id3 name3 tempid I have given dropdowns/slicers for…
Smit Rathod
  • 101
  • 6
1
vote
1 answer

What does Enhanced Capacity in Microsoft Fabric mean?

I'm trying to set up a Microsoft Fabric workspace by following below steps: Create 'Microsoft Fabric (preview)' instance from Azure Portal Create a new Workspace from 'app.fabric.microsoft.com' with below options: License Mode: Fabric…
Kuldeep Singh
  • 517
  • 6
  • 26
1
vote
1 answer

Microsoft Fabric, connect data pipeline to onpremise source

I am working with microsoft fabric and I need to create a data pipeline to extract information from a folder located on an onpremise server, but I don't see any connector from fabric that allows me to connect to this source onpremise, how can I do…
willy sepulveda
  • 159
  • 1
  • 14
0
votes
0 answers

Error while writing data to MS Onelake from Azure databricks

As currently it is not possible to create a shortcut in oneLake for private enpoint enabled azure storage so I am exploring another way to get the data from secure datalake to oneLake. According to MS Documentation, It is possible to integrate azure…
0
votes
0 answers

What is the equivalent of event hub and stream analytics in microsoft fabric

With MS Fabric becoming popular - what is the equivalent processing architectural unit in Fabric that can simulate Event hub + Stream Analytics , Event hub + Spark streaming
0
votes
0 answers

Microsoft Fabric Lakehouse size and table sizes

We have created a Lakehouse on Microsoft Fabric. It has a bunch of tables and files. In the Lakehouse explorer, I can see the files sizes just by clicking on the relevant folder or file in 'Files'. But, I want to know the size of each table in the…
0
votes
0 answers

Is it possible to connect directly to Dataflows from a Notebook within Microsoft Fabric, without using a Lakehouse?

We have a bunch of Dataflows (Gen1) set up in a Microsoft Fabric (Preview) premium workspace (these are mostly api connections to source operational data, with some Power Query transformations). I want to query the Dataflow directly within a Python…
0
votes
1 answer

How to have booth ZOEDER and VORDER on a single table

I have a table called Human and I want to apply optimization technique of Zorder on Region and Area with VORDER on the whole table. Can anyone suggest a sample code or explain what is Predator as per the documentation OPTIMIZE…
0
votes
1 answer

Authentication not granted for service principal token in MS Fabric API using Python

I am trying to connect to OneLake API in Microsoft Fabric using Python in VScode. So far I have Registered an app in Azure with these API permissions Then created a secret for my service principal Then I try to get the token with this function,…
0
votes
0 answers

Backup Microsoft fabric and prevent easy artifact deletion

We are considering to move our "classical" SQL data warehouse over to microsoft fabric. I noticed two things which both are possible showstoppers: I cant find any information on backups. How can we backup a fabric workspace (or at least a fabric…
0
votes
0 answers

Refreshing Lakehouse data during a notebook session in Microsoft Fabric

I am running a pyspark script in a notebook in Microsoft Fabric (preview). The script gets the last modification time of test.csv, which is located in a lakehouse in the same workspace. The problem is, as soon as you start the session of the…
0
votes
1 answer

Can i bring Google Colab codes to Microsoft Fabric? Or only locals IDEs

I have some code in Google Colab and would like to have it in Microsoft Fabric. But I did not find a direct connector. It's possible? Or do I need to unload and load them into Fabric? It would be interesting to have a direct connector.
0
votes
1 answer

querying virtual/external dataverse tables in SSMS, Power BI or anything other than Power Platform UI

I want to query my dataverse tables in something other than the power platform UI, which is limiting. I can connect to the dataverse using sql server management server & power bi, but none of the virtual/external tables show up. is there a way to…
wilson_smyth
  • 1,202
  • 1
  • 14
  • 39
1
2