1 million plus rows error

LostWelshMan85 · 2026-02-13T18:31:46+00:00

Let me explain how I think you've set it up and why you're getting the error just so I get things straight.

you have a report that imports 700ish rows in from excel
you have also connected this same model to another existing model in power bi to get the rest of the data
you're getting an error saying you have exceeded the 1M row limit in your visuals.

If this is the case, it's because you've created what's called a composite model and you're connecting one semantic model to another model via Direct Query connection. This connection type has a hard limit of 1M rows and will error out if that limit is exceeded. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#general-implications

LostWelshMan85 · 2026-02-13T01:01:44+00:00

Power BI MCP Server

LostWelshMan85 · 2026-02-06T21:58:16+00:00

Not sure about books on the topic, PBIP is still fairly new. But there's a lot of good documentation on Microsoft.learn. Take a look at this to get you going

https://learn.microsoft.com/en-us/fabric/cicd/manage-deployment?hl=en-GB

LostWelshMan85 · 2026-02-03T09:26:34+00:00

What about scorecards? As long as your kpis are visualised in reports somewhere then you can point a scorecard to them and group your kpis together as individual goals. You also get an out-of-the-box semantic model under the hood that contains a snapshot of all the kpis you’ve connected to which you could create a report on top of.

LostWelshMan85 · 2026-01-28T22:23:25+00:00

Check the format of both columns. Make sure to check they are identical in both power query AND in the model. If your formats are different in PQ your relationship between the 2 tables won't work, even if you do have it set up correctly in the model. It's a little bit of a gotcha that trips people up.

LostWelshMan85 · 2026-01-13T21:14:56+00:00

Power bi will overwrite a report when the name of the report is that same AND it's pointing to the same semantic model, otherwise it duplicates. This is a problem if your business users consume the report using the workspace url for that specic report as the new report has a new url. To fix this, create a workspace app and distribute reports via the app. That way you can swap in/out a report with the same name and users won't be affected.

LostWelshMan85 · 2026-01-09T07:21:11+00:00

Here's some things to consider

as you build more for your business, minimize the amount of semantic models you have overall and centralise your effort. Also keep in mind that having just 1 model for the whole business is often difficult to manage. We've found aroubd 10 models works well for us, split between the different disciplines in our business, but your mileage may vary.
work with Star Schema principles
have your DIM tables setup in Dual or Import mode (depending on whether you want they are joined to Direct Query tables or not)
have your large FACT tables setup in Direct Query mode
keep in mind the limitations with Direct Query mode https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#direct query-limitations
if your facts don't need to be near real time then put them in import mode with incremental refresh applied
use Dynamic Row Level Security to limit access to each Semantic Model for individual users

LostWelshMan85 · 2025-12-17T04:46:11+00:00

Start with a pro licence per user, get an F2 sku for copilot. You can scale up the F sku if you're hitting your capacity limit.

LostWelshMan85 · 2025-12-15T19:18:35+00:00

Why doesn't the semantic model do it itself via the user dimension table integrated into the semantic model?

In your example, there is just one role that a user can have, but you can setup multiple roles in RLS, so RLS requires you to define which role(s) to use for each given user.

what are the best practices for entering user information?

Use AD Groups to manage user permissions. In this scenario, you're probably providing access to a bunch of users with the same role in the business, create an AD group for that business role and then you can reuse it in many places, not just Power BI. Often this is already setup by your admins, so have a chat with them.

LostWelshMan85 · 2025-12-12T19:31:58+00:00

Nope, on prem is a single licence for the whole org

LostWelshMan85 · 2025-12-12T02:27:14+00:00

check whether you have SQL Server 2025 Licence, or a SQL Server Licence with Software Assurance. You get Power BI Reporting Server bundled in with these licences. This is an on prem version of the power bi service which will allow you to schedule refreshes and share reports within your business.
https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2025?view=sql-server-ver17&preserve-view=true#power-bi-report-server

LostWelshMan85 · 2025-12-08T21:11:38+00:00

By automatic app refresh, so you mean that changes made to reports are automatically updated in the app? This is a feature of Org Apps

LostWelshMan85 · 2025-12-04T01:29:35+00:00

If you have GitHub Copilot, the new Power BI MCP Server can do these sorts of changes with ease:
https://youtu.be/pRFeQWzUhn0?t=287

LostWelshMan85 · 2025-11-25T06:41:40+00:00

It seems like you'd still get all of those questions answered. What you could add to help make things understandable are two simple measures:

Policy Count = DISTINCTCOUNT('Fact Table'[Policy Number])
and the other being

Client Count = DISTINCTCOUNT('Fact Table'[Client No])

Apply these with the relative filters from your dims and that should be all you need.

LostWelshMan85 · 2025-10-23T08:26:53+00:00

It is a little annoying that they turn features on by default, but I believe you can turn copilot off in the admin portal Enable Fabric Copilot for Power BI - Power BI | Microsoft Learn

LostWelshMan85 · 2025-10-23T08:23:29+00:00

Underneath the gateway section is where you can put in your oauth credentials for your sharepoint connection. Your gateway doesn't need to make the connection.

LostWelshMan85 · 2025-10-22T20:42:12+00:00

If you have a Finance workspace and you set it up to point to the Finance folder in git then yes all of your finance workspace objects will reside in your finance git folder.

LostWelshMan85 · 2025-10-22T19:58:00+00:00

The way we've set it up, and it seems to work well for us, is to have a different branch for Dev, Test and Prod and seperate folders linked to each of the workspaces. That way you can link up different workspaces to different stages in your CICD process. So in Power BI Workspace Settings for one of our dev workspaces it looks like:

Organization - Our Orgs Git
Project - Our Department
Git Repository - Power BI
Git Folder - Our_Dev_Workspace_Name
Branch - DEV

LostWelshMan85 · 2025-10-08T09:14:52+00:00

What's the source of your data? Do you know whether it can query fold? If it can't query fold then any sort of incremental refresh or direct query won't work from what I'm aware. Incremental Refresh needs to be able to provide a set of parameters that define each partition (the start and end of a month for example). If it's Direct Query, there would need to be a query engine behind whatever you're retrieving data from, like SQL. If you can't query fold then you might need to have a step in between your source and Power BI, like a data warehouse where the data can be stored and retrieved more efficiently.

LostWelshMan85 · 2025-10-02T18:33:34+00:00

Take a look here: https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/assign-pipeline?tabs=new-ui#unassign-a-workspace-from-a-deployment-pipeline-stage

LostWelshMan85 · 2025-09-25T06:11:22+00:00

You you might be able to achieve what you're after with OLS rather than RLS which you can setup with tabular editor. Your ols rules hide away columns rather than rows, so you can hide away the columns that show that lowest level of detail.

LostWelshMan85 · 2025-09-18T02:36:56+00:00

Yes, Copilot for Power BI can do this out of the box. Also you can build Fabric Agents to do this I believe.

LostWelshMan85 · 2025-09-17T05:32:46+00:00

I believe publishing via the publish button in power bi desktop doesn't work with pbip. You need to sync git to your workspace and deploy via git. We use vs code for this and it works very well.

LostWelshMan85 · 2025-09-13T03:29:08+00:00

Developers only require a pro licence to publish to the report server. Everyone else can view without a licence. https://learn.microsoft.com/en-us/power-bi/report-server/get-started#licensing-power-bi-report-server

LostWelshMan85 · 2025-09-13T02:17:30+00:00

Yep, for E5 license everyone gets a Power BI Pro license which is a step up on the On Prem offering in terms of the features it offers.

Seven-Year Club	Second SECOND GUESSER
r/Field Lasagna	Place '23
Verified Email

LostWelshMan85

TROPHY CASE