Free public database

[Anonymous]

To be more precise: publicly accessible database

Long story short & precise: could you please provide PowerBi .pbix file  with connection to publicly accessible database?
File should contain couple loaded small tables available for transformation in PowerQuery.

So users can later open it refresh, change the list of tables to download, refresh data, transform downloaded tables, etc ...

In Details (generic problem): to support any question/answer post with example, besides of CodeExample you have to

1. Create insensitive DataExample
2. Store this example in publicly accessible cloud (Github/Googledrive...)
3. Provide Link
4. Consumer should download this DataExample
5. Connect it with Source code
6. ...

Normally, all these steps could & should be avoided

P.S. If I misunderstood approach in general, please share another one.

[Anonymous]

@amitchandak , thank you for sharing!

Frankly speaking, it's not exactly what I am asking for.
Idea is to have one single universal .pbi template that can cover 99.9% community question needs.

Advantages:

1. Just one file (no need to keep data files separately)
2. Small (as far as don't contain any data by default) and configurable (you just check tables )
3. Configurable for your particular question (you just select table(s), that you need, filter, transform etc...)
4. No need for additional downloads every time (or keeping sample db/excels on your PC)
5. ...

[amitchandak]

@Anonymous , You can use my sample or Microsoft data sample. In case you do not have access files, from Data view of power by you can copy table and paste it on excel

Dataset Link: Sample Data sets

My Files: https://github.com/amitchandakpbi/powerbi

Microsoft Samples: https://docs.microsoft.com/en-us/power-bi/create-reports/sample-datasets

Desktop Samples https://github.com/microsoft/powerbi-desktop-samples/tree/main/Monthly%20Desktop%20Blog%20Samples

you can check more details on power bi-related stuff: https://amitchandak.medium.com/important-links-every-powerbi-enthusiastic-should-bookmark-5682c7a3c912

How to copy paste : https://youtu.be/1_XlyzV-PcY