Microsoft Ignite Day 1 just ended and the new feature coming out of Fabric is the integration of Databases. You can learn more via the link below: https://learn.microsoft.com/en-ca/fabric/database/sql/overview

I have been tasked with ingesting data that is available from a Delta Share, this is a non fabric related open source data sharing standard. To make matters even more interesting the provider of the data is requiring an IP address for White listing. I have been looking on this forum and elsewhere and it seems that Fabric doesn't have static IP addresses because it is SaaS, however it can be used if they allow a range of addresses, is that a true statement? Also, has anybody used the "Delta Sharing" as a source in Data Flow Gen2, it is listed as one of the possible sources? I just haven't found anywhere that someone has commented about it.

I have two workspaces each with a lakehouse in it. I have my master data in edw workspace edw lakehouse. In the second workspace called analytics I have a lakehouse called analytics. The analytics lakehouse tables are all shortcuts to the tables in the edw lakehouse. I am an admin in both workspaces. I can reference tables in notebooks like this: df = spark.sql("SELECT * FROM dwp_Account LIMIT 1000") Recently we rolled out access to the analytics workspace to Data Analyst and Scientist. Currently the group they belong to is Contributor in analytics and viewer in edw. We keep getting the following error message when they try to run the same code in analytics "An operation with ADLS Gen2 has failed. This is typically due to a permissions issue. 1. Please ensure that for all ADLS Gen2 resources referenced in the Spark job, that the user running the code has RBAC roles "Storage Blob Data Contributor" on storage accounts the job is expected to read and write from. 2. Check the logs for this Spark application. Inspect the logs for the ADLS Gen2 storage account name that is experiencing this issue." I have given the group my user is a member of "Storage Blob Data Contributor" roles for both storage accounts in our Azure Tenant. Still doesn't work. Anybody have any ideas? Also, I looked at the logs but was unable to tell what storage account it was trying to use, does anybody know where I can find this out? Thanks.

Hey all! I was searching how to automatically suspend and resume fabric capacities and leave it running only on week days in order to save money or to scale up wihout exceeding the budget. So, I found this tutorial from Chris and Kevin where they show step by step how to do it. Since it's really useful and I haven't seen this posted here yet I thought of sharing it with you. https://www.youtube.com/watch?v=OHw-RJPW9SQ This is the link for the article they are using: https://richmintzbi.wordpress.com/2023/11/23/microsoft-fabric-capicity-automation/ In the article there is also the code for automatically resizing the capacity which can also be very useful, if you know the time you'll need more compute you can schedule when to scale up and scale down after a period of time.

We are writing some documentation for users of our fabric data warehouse. We would like to include hyperlinks from one notebook to another. Sort of if you need to create graphs use this notebook, if you need to import data with pyspark use this notebook. Does any body know how to reference one notebook from another in markdown cells? I tried the following, and many variations of it. "Link to [another notebook](Load_spark_Dealer.ipynb)"