Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Is there any way to automatically apply formats with data from SQL data source similar to SSAS data sources? Similar to the metadata imported when connecting to a SSAS Tabular database. With complex data models it takes considreable time to set all the formats and aggregation types across all the tables in the model. We have this metadata stored in a SQL databasd and would like to import it vs. manually setting each time a new PBIX document is started.
I don't think so, but this seems like a good idea to request - https://ideas.powerbi.com/ideas/
Also, though it is not going to help a lot, you can select multiple columns and format them - https://www.youtube.com/watch?v=j5kwmhoirM8
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 30 | |
| 23 | |
| 23 | |
| 23 | |
| 14 |
| User | Count |
|---|---|
| 46 | |
| 33 | |
| 20 | |
| 18 | |
| 16 |