Error when trying to edit a Semantic Model in a Warehouse
I have a Warehouse and Semantic Model. I am trying to do some basic stuff that was fairly ubiqutious in Power BI Desktop, like set the Display folder property, or set the Summarize By property of a numeric field. But the funny thing is: the error mentions a table name that is NOT the table that contains the field I am trying to edit. The error mentions my dimDate table, which was recently dropped, recreated and re-populated with additional columns (because you can't do ALTER TABLE ADD <column> in Fabric Data Waterhouses), and my Power BI model (connected via Direct Lake) only shows the OLD version of dimDate without the extra columns. It's like something is stuck and that there are TWO tables named dimDate that is causing conflicts. I did a DROP TABLE dbo.dimDate, and the Warehouse Semantic model picked up that fact immediately. But my Power BI file does not, even after a refresh. What's more, I create a new Power BI file and connect it via Direct Lake to the Warehouse and it sees the old dimDate table (that is no longer there). How do I get my Power BI Direct Lake model to recognize the Semantic Model in its entirety, with nothing extra? Oh, and even after deleting dimDate, I still cannot assign a Display Folder to a column. IMHO, Fabric is NOT ready for prime-time 😞
ETL on Fabric
Hey Guys, I'm new to Fabric, I'm trying to wrap my head around which services I should be using and in what order. I'm trying to reverse engineer our current ETL process for our existing data warehouse on SQL server database. Our ETL is incremental so every day we receive revenue files for yesterday, we also pull data for legacy databases etc... I designed a quick diagram to illustrate how I'm thinking of designing it after I read Fabric documentation. Here are my questions based on the diagram below: 1. What service should I use to push my files from Data Lake Storage Gen2 (DLS) to Lakehouse? 2. Does Dataflow Gen2 do the same thing as Notebook if not, can you please provide an example? 3. How does the Dataflow Gen2 knows that there is a new file in the Lakehouse and it needs to process it? 4. is the Data Pipeline purpose in this diagram just to push the data to the Warehouse? 5. The second image represents the services on Fabric, is it possible to tell me in which order I should start using the services, could you please number each service in the right order of use? Thank you
