dataflows
7 TopicsBUG::semantic model inaccessible when creating a report with Power BI persona
Issue: can't access previously created lakehouse from Power BI persona UI. Clicking on New report --> Pick a published semantic model --> select model, gives the error below: Underlying Error: Capacity operation failed with error code CannotRetrieveModelException Activity ID: d25b479d-6c03-4aee-b6d8-ff034ba450e8 Correlation ID: cb485f01-ca36-a07f-fd98-3610436063fb Request ID: f4dac7ef-cddf-097c-bb38-1f47336bd5e2 Time: Thu Feb 15 2024 04:08:11 GMT-0500 (Eastern Standard Time) Service version: 13.0.22638.74 Client version: 2402.1.17926-train Cluster URI: https://wabi-canada-central-redirect.analysis.windows.net/ Again, what on earth is going on???Solved12KViews0likes18CommentsNew powerbi semantic model based out of the lakehouse in the workspace is not getting updated
I created a new powerbi semantic model(not the default model present in the lakehouse) based out of the lakehouse in the workspace but the powerbi semantic model is not getting updated when the changes are made in the lakehouse or the dataflow. For example I added a new column in the dataflow which got updated in the lakehouse but not in the powerbi semantic model which was created in the workspace686Views0likes3CommentsPower bi scheduled refresh
I have setup a report with a dynamic dataset and a dataflow. Dataflow consists of a dataset which is refreshed daily and hence required a scheduled refresh. The dynamic dataset requires manually refresh once a year. Now after dataflow being refreshed I can see new data in the table but the visuals don't update. The load and direct refresh settings have already been enabled, still the visuals don't update automatically. Please help, thanks in advance.1.3KViews0likes5CommentsFiltering semantic model for end-consumer
Hi everyone, We're implementing an end-to-end solution using Microsoft Fabric, including Dataflows Gen2, Pipelines, Lakehouses, and Warehouses. However, we’re facing a challenge and need your advice regarding the following. Our Workflow: 1. Ingesting data with Dataflow Gen2 for multiple clients into a lakehouse. 2. Enrich this data in another lakehouse. 3. Load the completed data into a warehouse. 4. Creating a semantic model with relationships and measures based on the final warehouse. The Challenge: We need to extract data for a single client into an Excel template, despite having multiple clients' data in the warehouse. Ideally, we want to connect the Excel template to the semantic model (containing measures and data model) linked to the final Data Warehouse and filter this model to load only the data for the selected client into Excel. We're using the "Analyze in Excel" function with the semantic model or a connection string. Previous Approach: Previously, we connected Power BI Desktop to a SQL connection string, filtered client data in Power Query, and published the filtered data to the online service. However, this approach isn't scalable for our growing number of clients. Since we can't update the semantic models when the Power BI Desktop template changes. Options Considered: 1. Direct Connection with Slicers: Connecting the Excel template directly to the semantic model and using slicers to filter client data. This approach loads all rows, affecting performance and potentially exposing other client data. 2. Old Approach: Connecting to the data warehouse, filtering in Power Query, and publishing a separate semantic model. This is not ideal as we want a centralized semantic model from the warehouse. 3. VBA or MDX Queries: Exploring VBA or MDX queries on the connection string, but due to limited experience, I couldn't get it to work. Something like SELECT * FROM [Client] WHERE 'Name' = 'FilteredClientName' in the command text would be something that would be enough. Question: How can we filter a semantic model to show data for only one client before connecting it to Excel with a connection string? Any guidance or alternative approaches would be appreciated. At this point, open to anything. Thank you for your help!Solved4.9KViews0likes8CommentsParquet File Loading in Dataflow
Hi I tried loading parquet file from my OneDrive of size 200MB in power bi dataflow but it throw an error of Parquet.Document cannot be used with streamed binary values. It works well with parquet file of smaller size. I am attaching the screenshot with the error. is there any solution for this error?Solved3.4KViews1like6CommentsUnable to save datamart - DmsPbiServiceUserException
I have started getting an error on my datamart: Unable to sync the datamart with the automatically generated dataset. Some reports may not be updated. To try to repair this, select Transform data and then select Save. When I try to to do the above, it generally proceeds through the loading data phase, then throws an error during the "Wrapping things up" phase of the type DmsPbiServiceUserException. The full error is below. The issue seemed to occur around the time of updating ownership of the datamart. One other post PowerBI Datamart Error Message - Microsoft Fabric Community seemed to reference a "phantom" dataverse connection in the manage connection screen--I also have a dataverse connection here which is not being used. Deleting or keeping it seems to make no difference. It would be great if I could get this DM back up and running--would be nice to to have to recreate the entire thing as seems to be the go-to suggestion in other threads. Activity ID: 92deaf0a-7666-8375-1c0a-b748b4cecc6c Request ID: 1332af23-2537-4c37-8922-d0269f423f85 Status code: 500 Error Code: DmsPbiServiceUserException Batch ID: 51dee642-34ba-4906-bb6e-fee3c6dfb66e@aa252125-69e3-440e-9a86-fe5f401a3d7a$2023-11-06T15:56:05.8614165Z@3be0cde6-9ac9-410a-94a8-50c151fb5128 ErrorMessage{"error":{"code":"ExternalServiceUserFailed","pbi.error":{"code":"ExternalServiceUserFailed","parameters":{},"details":[{"code":"ModelingServiceError_Reason","detail":{"type":1,"value":"Error in ModelingSession creator connection to AnalysisServices"}},{"code":"ModelingServiceError_Location","detail":{"type":1,"value":"Connection to AnalysisServices"}},{"code":"ModelingServiceError_ExceptionType","detail":{"type":1,"value":"ModelingASOperationException"}},{"code":"ModelingServiceError_Message","detail":{"type":1,"value":"The database was not found in Power BI. Please check if it was deleted, or if you do not have permission to access it. Redeploying the database may also succeed, if the database can be recreated.\r\n"}}],"exceptionCulprit":1}}} HttpStatusCode400Solved2.2KViews0likes5Comments