When I load data in Power BI from Fabric Warehouse or Lakehouse, I can see all the queryinsights and system tables. I want to control other member can't see those tables when they load data in PBI. Can we control table access in PBI??

My team is working with Fabric and we are testing several features. I have some questions about the Lakehouse Schemas which is preview features now. I read this documentation but I can't understand some limitation, 'Non-Delta, Managed table schema' is not supported. And the migration one too. Do they support 'Migration' features in original Lakehouse? We already migrate the tables from Lakehouse_01(non-schema version) to Lakehouse_02(schema version) with notebook. Can anyone explain about those limitation?

I have some question about the migration from Power BI to Fabric. Can we migrate the semantic model itselt from Power BI to Fabric? If you have any use cases or example, it would be very grateful to be shared :)

Hi everyone, Could you please assist. I am trying to use a cursor in a Fabric datawarehouse. The query is working fine on an on-prem SQL server, but It gives an error @@FETCH_STATUS not supported. The question is: Can we use cursors in a Fabric Warehouse ? If not what is the alternative? What I am trying to do here is to union all my cloned tables and then return then in one query. The tables are shown below. I just want to see if its possible. Below is the code: (You can change the '%demo_test_clone%' to any table you have on your warehouse. declare @SqlCommand as nvarchar(max) declare @TableName as varchar(50) declare @int as integer set @int = 1 declare CloneTables CURSOR FOR select name from sys.tables where name like '%demo_test_clone%' Open CloneTables fetch next from CloneTables into @TableName while @@fetch_Status = 0 begin if @int = 1 begin set @SqlCommand = concat('select * from ', @TableName) set @int = 2 end else set @SqlCommand = concat(@SqlCommand, concat('union all ', @TableName)) fetch next from CloneTables into @TableName end Close CloneTables Deallocate CloneTables EXEC sp_executesql @SqlCommand

@Musili Adebayo has created a great end-to-end project, check it out here 👉🔗 View on Medium 👉🔗 View on LinkedIn As Musili mentions in the article, the project showcases the following: 1. Create a New Lakehouse. 2. Get data into the Lakehouse using various methods of data ingestion such as Shortcut, Data Pipeline, DataFlow, and File Upload. 3. Perform Data Modelling. 4. Finally, Data Visualization of the ingested table (Optional). Great job Musili!!