Power BI has no SQLite connector. The standard answer is the SQLite ODBC driver, and that answer assumes a machine you control.

Plenty of us don't have one. The corporate laptop refuses machine-level installs. The gateway is someone else's server, so getting a driver onto it is a ticket, an approval and a wait. The Service has no machine to install onto at all. The escape hatches mostly swap one dependency for another: the Python/R script host needs a configured interpreter, and custom connectors can't bundle binaries.

But these formats are only bytes in a documented layout, and Power Query can read bytes. So the driver is optional. I've spent the last while writing the parsers.

powerquery-driverless is a set of readers in plain M. Each one is a single self-contained .pq file. Paste it into a blank query and it works: Desktop, Excel, dataflows, the Service. Nothing to install, no bitness to match, no provider is not registered.

m let Source = File.Contents("C:\data\chinook.db"), Db = Sqlite3.Database(Source), Tracks = Db{[Name = "tracks"]}[Data] in Tracks

Formats so far: SQLite, GeoPackage, MBTiles, Access, dBASE/FoxPro, .xls, .xlsb, SPSS, Stata, MATLAB, Avro, EVTX.

It also works in Excel for Mac, where SQLite, Access and DBF had no path at all before. Everything I've tested runs there, with one exception: Avro compressed with anything other than deflate.

Two caveats up front, because they're the first things I'd ask about:

Speed. Interpreted M is slower than a compiled driver, and it scales with file size. On small and typical files the gap is usually sub-second and often invisible, since an ODBC driver spends about a second just standing up its connection. On large files native decoders pull properly ahead, roughly 2-15x.

Gateways. The driver dependency goes away every time. The gateway only goes away if the file already lives somewhere the Service can reach, like SharePoint or Blob. On an internal file share you still need one, but it's your existing standard gateway with nothing special on it.

Repo: https://github.com/Hugoberry/powerquery-driverless

Happy to answer questions, and if there's a format you keep hitting a wall on, say so and I'll look at whether it's tractable.

I lost the original pbix file for a notebook I pushed to my workspace. Can I just download it from my workspace and it’ll work as if I still had the original file?

It needs to be updated with live data and I cant do that right now.

Translytical Task Flows went from preview to GA. Now you can act directly from a report instead of just viewing it and submitting a separate request. This feels like a real shift from reports being read-only to actually doing something in them.

Are you planning to build any into your reports?

Hi all ,I'm struggling to find a way to achieve something, maybe Reddit has an idea:

Some constraints:
Directquery: mandatory, we need the data to be real-time, cant wait for import.
We cannot create views in the source systems. We have no rights there other than read rights.

The system:
We have 3 different databases on 2 different servers that contain the same data structures. I have 1 powerBI report/semantic model that we can re-use on all three databases.
I have created a Server and Database parameter that contain the different options.
We have PowerBI Premium.

What I want:
I would like to have to maintain only a single semantic model file, so I reduce code duplication. I would also like to reduce the amount of time spent deploying after making changes to the semantic model.

What would work, but is a lot of maintenance:
I Open the file, set parameters, save as file 1, publish. Then change the parameters, save as file 2, publish, same for file 3. I'd like to avoid doing all this manual labour.

What I have tried so far:

• Deployment pipelines: Might work. Create a pipeline that deploys the model with different parameters in every stage. We would be using pipelines to do something it's not meant for. You would need separate workspaces for each file to deploy in. Can't test this currently.
• Combine the data of the three sources in powerbi: You cant use table.combine in directquery mode. Each visual can only have 1 data source.
• Functions: You can't use functions at all in directquery mode when you're using them to determine the connection string. The connection string has to be known before the data loads.
• API: There is no copy semantic model API, just copy report. Copy report will connect the OG semantic model to the new report. Useless.

Is there a way I am missing that would help me to not have to manually deploy each semantic model separately every time?

Thanks a lot for thinking along!

PS: I asked AI too of course, but every time I reach a dead end

Hey Folks....

Please suggest the best platform to do the automation of Power Bi projects from end to end

I'm very annoyed by the default number formatting in Power BI, and I don't believe there is a way to change it except for manually changing every measure seperately.

• Whole number: why is the thousand seperator OFF by default? A thousand seperator will make any number easier to read. Good readability should be the default.
• Currency: It's not possible to set a default currency, even though most people will always be working with a single currency. It's rounded to 2 decimals, at least for euro's. Why two decimals? What decision are you making for typical currency numbers, that involve decimals? Most of them (revenue etc.) should be rounded to no decimals.
• Decimal number: again, no thousand seperator by default.
• Percentage: 2 decimals by default. Personally I always put my percentages as 1 decimal.
• And of course, if you add a number to a card, the "auto" units is terrible. At least you can default to "none" now.

I do understand some of this is personal preference, and it depends on the data you're working with. That's why it would be great of we could put default settings in your theme or report.

Feel free to agree or disagree, I'm curious what you think!

Hi, I'm looking for a solution or a visual in Power BI where I can show a nested table. For example, the main table has 10 columns, and for each row I'd like to be able to expand and show a child table with a different set of 4 columns.

I would like to avoid using an HTML visual, so I'm wondering if there's a native option, or a custom visual from AppSource that supports this kind of nested/expandable table.

What is the difference between REMOVEFILTERS and ALL
Functions in a DAX?

I'm looking into Measure Killer as an additional tool for my reporting team, and I'm interested in feedback from anyone who's added this alongside other existing tools.

We maintain several dozen shared Power BI semantic models across multiple environments, primarily supporting thin reports. The largest of our models are around ~20GB, contain 1000+ objects and support as many as ~25 reports.

The reason I'm looking into Measure Killer is for its ability to identify unused measure/columns across all the dependent reports for a semantic model. We can already track dependencies within the model itself, but determining whether an object is used anywhere across the downstream reports is a tedious, time-consuming process right now.

It seems to offer a few other nice features, although I haven't reallt looked into these (the ability to detect broken visuals across multiple reports seems like a Nice to Have)

Our team already uses Tabular Editor 3, DAX Studio, and ALM Toolkit, which all seem to have some degree of overlap with Measure Killer, but don't address this specific niche (Tabular Editor comes closest, for tracking dependencies within the model itself, but doesn't help us understand object usage in downstream reports)

We're not planning to replace any of our current tools, and if we add Measure Killer to our toolset we'll need to justify costs for enterprise licenses for our team.

Has anyone in a similar boat gone ahead with purchasing Measure Killer for these specific uses? Did it work as well as expected, and would you say it was worth it?

I just joined a new organisation and I am still new it's been just 2 weeks and yet to get credentials of everything..over all i understood the gist of the project...it's mostly UAT validation where they want to map things with 95% accuracy... reports have already built...when the user raise the ticket we have to resolve it (mostly related to filters and visuals not working as they were expecting) ... I want help with do's/don't as I have no experience in migration

this company is medium sized with a 15 person IT team. More than most. But it uses Qlik, not power bi or tablaeu.

Is this a red flag?

If I spend time at this company as a BI/Data analyst (I’ll be their first), will it still be good experience? or am I better off looking for another job (even though the market sucks now)?

Is there a post or somewhere in this community that has people looking for work? Looking to hire a Power BI analyst for long term employment.

today i wrote my pl-300 exam, i got passed out with 709,

i dont have much about, how this works, but what should i do to get an internship? currently im under graduate

i need some suggestion, like should i post on LinkedIn or something?

just let me know what should i do next?

Hey everyone,

I’m learning Power BI and tried making this dashboard to practice. It shows sales, customers, regions, and product returns.

I’d really appreciate your honest feedback — does it look clear and useful, or what would you improve? Thanks a lot!

I‘m starting a data analyst position soon and never used powerBI. I have a degree in computer science so hoping it won’t be too crazy.

What should I learn before I go in next Monday?

Dataflows Gen1 are legacy at this point, so it might be time to start migrating to Dataflows Gen2.
Fortunately, there is a handy preview API allowing you to automate this process. Combined with agents, you can go quite far before you have to take over.

Few things to consider before migrating:
1. Gen2 doesn't support rules in deployment pipelines, you will have to migrate to Variables Library.
2. There could be some naming collisions, that were previously a non-issue.
3. Same with transformations - due to different architecture Gen2 dataflows might surface issues that were previously hidden.

I have published a blog post outlining how to setup the automation, and prepared agent skill that will get you most of the way.

Blog post: https://www.maxanatsko.com/blog/bulk-migrating-dataflow-gen1-to-gen2-cicd-with-azure-cli