Semantic model on warehouse: Field list item has errors
Hi, since monday or tuesday i get the following warning for every table in all semantic models: Nothing has changed on the warehouse. I cannot find more. at first glance, everything seems to work fine... Does anyone have an idea what it could be? Thanks!
Single User error trying to pull data from Warehouse in PowerBI
Hi, I have ONE (1) individual in my organization who is unable to use PowerBI to query the SQL endpoints for any data warehouses/lakehouses in our PowerBI web service. The error they are getting is "Unable to complete the action because your organization's Fabric compute capacity has exceeded its limits." The error does not make sense for the following reasons: No one else in my organization receives the error when using PowerBI to query from the warehouse or lakehouse The user IS able to query from the warehouse when using DBeaver (Database tool), Power Query in Excel, and access the warehouse directly from the web. The user installed PowerBI from the Microsoft store like everyone else in my organization. The user has also tried uninstalling and reinstalling but no success. The user is an administrator in the workspaces that house the warehouses. Has anyone else encountered this issue or have suggestions on other things we can try? All of my research tends to point to the Fabric capcity being the issue but again, this is a problem for only a single user no one else in my organization has this error message. Thank you, CameronError 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 youError "Lock request time out period exceeded" when creating a new measure on semantic model
Hi guys, We used to work with Fabric for months now on the trial. Since this week we switched to a reserved capacity F64. I was able to create some measure before on this same model, but now I get this message when tring to create a new one: Underlying Error{"batchRootActivityId":"a4f162b1-b688-4eef-883a-8a9aceb14610","exceptionDataMessage":"Lock request time out period exceeded."} One thing I find strange is in the message you see at bottom it refers to region South central US which was the region for our trial capacity. But our reserved capacity for which I am getting the error is locatd on East US2 region. But maybe it's not related, I don't know. Haven't found anything on forums about this issue. Looks lke a bug. Really annoying... Thanks
Cannot create a Time Intelligence Measure in the Warehouse
Hey everyone, Good day! I've run into a weird scenario. In Power BI Desktop, I was able to create quick measures, especially the time intelligence ones. But the moment I throw the DAX into the Warehouse, it didn't work. The ".[Date]" part of the code is not working. I've got this column that's tagged as 'date' in my dataset, but it's like the Warehouse is playing blind. Anyone else tried making time intelligence measures in the Warehouse? A little guidance would be gold right now. 🤔 Below is an example of the DAY I copied and paste from Power BI Desktop to MS Fabric Warehouse: Count of event_type MoM% = IF( ISFILTERED('table'[column]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), VAR __PREV_MONTH = CALCULATE( COUNTA('table'[column2]), DATEADD('table'[column].[Date], -1, MONTH) ) RETURN DIVIDE(COUNTA('table'[event_type]) - __PREV_MONTH, __PREV_MONTH) ) Kind regards, Luci
Updating Power BI Dataset Metadata Connected to Fabric Data Warehouse
Hello, I have created a Power BI dataset from a Fabric Data Warehouse. In this dataset I created a relationship, added a few measures then created a report. I realised that I needed an additional column in one of the tables in my dataset. I updated a Dataflow Gen2 process that refreshes a Lakehouse which forms part of my ETL process before the Warehouse and added my new column. I then dropped the table in the Warehouse and modified the Data Pipeline destination mapping to add my new column. This all went successfully and my new column in my table in the Data Warehouse. The problem is, the new column is not showing in my dataset. I have tried refreshing and exploring all the options in the GUI but I can't figure out how to get this new column to show. I have found that by deleteing the measures from the table, removing it from the model then re-adding it, I can get the new column to appear. This is not a viable solution however because I have to recreate all my measures, relationships and formatting for every new field I want to add. Does anyone have any ideas?
Views from SQL Endpoint/DW not showing up when creating a new dataset in Fabric
I am testing out Fabric in the preview/trial version. Here's what I did:- 1. Created a Lakehouse. 2. Imported some Salesforce data using a Dataflow Gen2 with destination as Lakehouse. 3. Opened up the SQL endpoint and I see the table I imported 4. Created a view using the data from the table 5. Created a new dataset and tried to import the view. However, the view does not show up in the list. Is there any reason why it wouldn't show up or is it just a bug?
