Forum Discussion
Free public database
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
- Create insensitive DataExample
- Store this example in publicly accessible cloud (Github/Googledrive...)
- Provide Link
- Consumer should download this DataExample
- Connect it with Source code
- ...
Normally, all these steps could & should be avoided
P.S. If I misunderstood approach in general, please share another one.
2 Replies
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
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:- Just one file (no need to keep data files separately)
- Small (as far as don't contain any data by default) and configurable (you just check tables )
- Configurable for your particular question (you just select table(s), that you need, filter, transform etc...)
- No need for additional downloads every time (or keeping sample db/excels on your PC)
- ...
