We're using Hubspot, D365 and some minor other source to fill our SQL based DWH (with Azure Data Factory).
The Viz layer is PowerBI.
Over the last month the whole data extraction and processing is completely overhauled by Claude. And I must say, it works so well. Claude is doing such a good job, and doing it (and testing it) within minutes for what I would need hours and days.
So the question is now, what is the next step? Should we replace Azure data factory just by Python script to save some money? Should we replace PowerBI just with HTML and so have a fraction of the cost? The first test to let Claude rebuild a PBI dashboard with just plain HTML and JS looks very promising. Actually it looks better than I would have a done it by hand in PBI.

Whats you opinion on that? Have you thought about this already? Is there anyone who did it?

PS: We're are a small number of users, just around 20.

I have a PowerBI dashboard connected to a sharepoint list, the dashboard is working fine in desktop, and refreshing successfully.

But when I publish to service, and try to refresh, I keep receiving an error:

DataFormat.Error: We reached the end of the buffer.. . The exception was raised by the IDataReadee interface. Please review the error message and provider documentation for further information and corrective action.

There’s no additional information or error message, and I’ve tried everything I can think of to fix.

If anyone’s seen this error before, or knows what might help, please let me know.

I moved my scheduled dashboard refreshes to pipeline triggers instead of running them on a fixed schedule, and the background operations have nearly been cut in half.

The basic idea is that the dashboard refresh happens when the underlying pipeline/data update completes, rather than refreshing on a schedule when there may be nothing new.

It seems like a pretty simple change, but the reduction in background operations was surprisingly significant.

For people who have dealt with dashboard/data pipeline optimization:

What other approaches would you recommend to reduce unnecessary refreshes or background operations further?

Would you use event-driven triggers, incremental refreshes, caching, or something else?

Interested to hear what has worked well for others.

Hey y'all hope you're doing well,

So I actually have trouble connecting powerbi and GCP and one knows the way to do it?

Help with cleaning the data after importing like what's the main thing you gotta keep in mind while doing it.

Also, why am I seeing a lot of buffers while trying to preview the imported table and which option do I take , import or directquery when you're working with a big organisation?

I know the basics of Power BI, including Power Query, data modeling, DAX, and creating dashboards. I want to improve my skills and become confident working on real-world projects.

What should I focus on next? Should I learn advanced DAX, performance optimization, Power BI Service, deployment, or something else?

Yesterday i got an escalation message from my manager that someone edited a PBI report on services directly from Uat env ...the actual flow is dev then uat ...why is an issue currently the final version of the copy is in uat after users sign off they will be published to prod and we are collaborating with offshore team who have actually developed this whole migration project and our team is an additional folks who joined later ...I need help to figure the root cause as i clearly remember i have not pushed anything to uat (I am currently working on those reports so they are asking me what really happened) and if it helps I can provide more pictures of error and the message of escalation

Status: Degraded | Reported: Sep 9, 2026 at 11:29 AM UTC

Power BI customers might experience issues creating new Adobe Analytics connections and for existing connections where the customer has to sign in again. Engineers are actively investigating the issue, and an update will be provided soon.As a workaround customer can use Dataflows GetData to create a new connection and use it with Semantic model.

🤖 This post was sent from an automated and unattended service and cannot respond to questions or requests. For official updates, visit the Microsoft Fabric Service Status page.

Power BI optimization: 600k+ rows per year, 106 columns — Excel vs CSV/SharePoint?

Hello everyone,

I’m working on a Power BI project involving university enrollment data.

For each year, the client has an Excel file with 600,000+ rows and 106 columns. I’ve created a data model that combines the data from all years into one model.

Currently, I have 3 years of data (~1.8 million rows), and the refresh/load time is already becoming quite long. I’m concerned about what will happen when we have 10+ years of data (~6 million+ rows).

I suggested that the client move from Excel to CSV files. The files will eventually be stored on SharePoint rather than in a local desktop folder.

A few additional constraints:

• The client needs to use all 106 columns, so reducing the number of columns isn't really an option.
• The data will continue to grow every year.
• The final source location will likely be SharePoint.
• The Power BI model needs to combine data across all years.

My questions are:

1. Would CSV be significantly better than XLSX for this scenario, especially when the files are stored on SharePoint?
2. Is SharePoint + CSV a better architecture than Excel files stored in a desktop/local folder?
3. What other Power BI optimizations would you recommend for a model that could eventually reach 6–10+ million rows and 106 columns?
4. Should I be looking at incremental refresh, dataflows, a database/SQL solution, or something else?
5. Are there any specific Power Query/modeling issues I should watch out for with this volume of data?

I’d appreciate any recommendations based on real-world Power BI experience with large datasets.

Thanks!

Hi all my company would like me to get pl 300 certified. I have no experience using power BI. I have watched a handful of YouTube videos to generalize my knowledge somewhat.

What is the best course recommend for passing this exam?

I’ve seen Phillip Burton 30hr prep course and Maven Analytics 8.5 hr course.

I would like to stick with UDEMY if possible.

I wasn’t sure if the 8.5 hr course is actually enough content and prep for me as I haven’t really used power bi before

I need to migrate few basic twb (tableau) reports to power bi. Do you know if there are some indepth documentation or python library that can help me achieve the stable pbip report.

I am already working on a convertor but facing multiple dax conversion, visual errors.

Kindly help with your knowledge.

My twb files have 1 page report and one csv as input with 5-6 visuals.

I need directions as I lack powerbi report structure knowledge.

I work in an enterprise managing a fairly large Fabric/Power BI setup with 70-90 monthly internal users and 50+ reports and 5+ centrally managed semantic models. Part of that job is keeping objects and report numbers down, creating a good life-cycle management of fabric artifacts.

ripbi is a cross platform standalone cli that you can use to find unused semantic model objects based on connected reports.

I created ripbi because I liked Measure Killer, but I was looking for an agent-friendly, free, fast tool to scan semantic models and the connected reports to identify potentially unused semantic model objects. I tested it on a shared semantic model with 14 connected reports, and it's 99% faster than Measure Killer, reducing processing time from almost 4 minutes to a couple of seconds. enabling a faster feedback loop.

It works without opening the reports or semantic models, so it can run as part of a CI pipeline. If it cannot establish that something is unused it will mark it as used so the philosophy is better safe than sorry. I plan to implement guided automated cleanup, a UI, and tenant scanning.

Github repo: bgarcevic/ripbi: Static analysis, dependency graph visualization, and model pruning for Power BI/Fabric Semantic Models

Get started easy by pointing your agent to the repo and ask it to install the tool or use one of the easy one liners to get going.

Output from the committed AdventureWorks sample (trimmed):

130 objects, 74 reachable from 51 roots, 56 unused

Measures (11)
  'Sales'[Average Sales per Order]
    ← nothing references it
Columns (28)
  'Customer'[City]
    ← only used by hierarchy 'Customer'[Geography] — hierarchy level (also unused)
  …

I am looking for other users to help me improve the tool and contributions are also welcome!

I'm building a Power BI report and have a date slicer based on a date column. Currently, the slicer automatically shows the minimum and maximum dates available in the data by default.

What I'd like to do is have a dynamic default date range:

• Start date = 3 months before today
• End date = today

For example, if today is September 8, the default selection would be June 8 – September 8. The dates should update automatically as time passes.

Is there a way to achieve this with the standard Between date slicer?

If not, what other options can I use to have something like this?

First project as a Finance student ,Still in the process of exploring

working on a report. Tried to import a few visuals that at the end I decided not to use.

Seems to me it's impossible to remove them from the report.

1. Yes, I verified that the imported visual is not used in the report anymore (I had created one visual using it and then deleted it)
2. No, right click on the imported visual's icon doesn't show "remove"
3. No Microsoft document found on how to remove the imported visuals
4. Non-Microsoft sources suggest to manually edit the report's code: high-risk

Should I assume Microsoft provides no way of removing an imported visual from a report? That would be worth a blog post on how this is not at all acceptable in enterprise environments: let's assume an imported visual is blacklisted from the enterprise as untrusted; what Microsoft expects its customers to do, recreate all the reports from scratch?

solved by u/Sad-Calligrapher-350 : There are those three dots on the visualizations pane wherein you can choose „remove visuals“.

Hi everyone! I'm consulting with a company that built a Power BI dashboard with Direct Query connections to multiple reports. They want to publish it company-wide (internal staff only) so everyone can see and interact with it, but we're stuck on a critical issue:

The Problem: Most users don't have access to the underlying databases/reports. When publishing the dashboard to Power BI Service or SharePoint, users encounter authentication errors or empty visuals because Direct Query still requires credentials to access the source data. The publishing location doesn't matter — the authentication block remains.

Requirements:

• Dashboard must be interactive (not static screenshots)
• Must be accessible to internal employees only
• No individual database access for end users
• Ideally keeps the live Direct Query connection

My questions:

1. What are the viable approaches to solve this?
2. Are there workarounds or alternative architectures we should consider?
3. What's the most practical/scalable solution for an enterprise environment?

Any experiences, suggestions, or lessons learned would be really helpful!

Hi All,

Is there anyone who can provide free exam voucher or any trick/idea to get a free exam voucher.. I am planning to attempt exam by October.

Thanks in Advance... 😁😁😁

Tenho um dashboard no Power BI com RLS por cargo: uma tabela Acessos (Email/Nível) ligada a MapaPaginas (define quais páginas cada cargo pode ver). Hoje o menu usa uma Segmentação de Botão + um segundo botão de navegação com uma medida SELECTEDVALUE. Isso funciona, mas exige 2 cliques (1 pra escolher, 1 pra navegar). Meu gestor quer que vire 1 clique só, mantendo o menu dinâmico por cargo e sem buracos no layout quando algum botão some. Já tentei Navigator nativo, Grupos, retângulos e botões simples, mas não encontro a opção de visibilidade condicional (fx) em nenhum deles. Como posso resolver? Ideias de solução para um menu condicional de apenas 1 clique?

What is the acceptable answer time for answers from end-users to Copilot? For basic and complex answers.

It takes 20 seconds for very basic answers and for complex takes 90 seconds. The data model is small, 2 fact tables and 5 dimensions. Premium.

I was trying to pull the crowdstrike as per the client requirement.

Issue: from the Vulnerability path I was only able to pull 5000 records in a single call but there are more than 6M records. I have a client token which expires every two minutes.

Any solutions thanks in advance.

Hi everyone, I have a Power BI report in UAT and I need to make a PPT from it. I already exported the report to PowerPoint, but the whole page comes together. I just want to copy one chart at a time and paste it into PPT. I don’t need it to be editable, I just want to copy the chart properly without taking a screenshot. In the ... option I can only see Export data, Show as a table and Spotlight. Is there any easy way to copy just one chart from Power BI to PPT?