User
Write something
Canโ€™t create measures or see views in report from Fabric Lakehouse
Hi all, Iโ€™m building a Power BI dashboard in Microsoft Fabric using a Lakehouse as the source. When I click "Create report" from the Lakehouse, I can only see the tables, not the views Iโ€™ve created. Also, Iโ€™m unable to create new measures or calculated columns within the report. My goal is to build visualizations based on views, not just raw tables. Is there a way to enable views in the Lakehouse UI or make them accessible in Power BI for reporting? Also, is it expected that measure creation is disabled in this context? Appreciate any help or clarification. Thank you!
1
0
Fabric pipeline copy data from PostgreSQL to warehouse doesnโ€™t preserve relationships (PKs/FKs)
Hello everyone, I'm new to Microsoft Fabric and currently working on data pipelines that copy data from a PostgreSQL database to a Fabric warehouse. The data copies successfully, but I noticed that primary keys and foreign key relationships are not transferred to the warehouse tables. All the tables are created, but the relationships between them are missing. (over 550 tables) Is this the expected behavior? Is there a way to preserve or automatically recreate the primary/foreign keys during or after the pipeline execution? Any advice or best practices would be appreciated. Thanks!
1
0
๐Ÿ‘‹ New joiner? Welcome! Start here ๐Ÿ‘‡
Welcome to all new members, here's some links and information to help you get started! ๐—ค๐˜‚๐—ถ๐—ฐ๐—ธ ๐—Ÿ๐—ถ๐—ป๐—ธ๐˜€ ๐˜๐—ผ ๐—ด๐—ฒ๐˜ ๐˜€๐˜๐—ฎ๐—ฟ๐˜๐—ฒ๐—ฑ - For an introduction to this community โ†’ Explore the Welcome Pack - New-ish to Fabric? โ†’ Check out our Fabric Foundation module - Studying for the DP-600? โ†’ Check out the DP-600 Module and the DP-600 category - Studying for the DP-700? โ†’ Check out the DP-700 Module and the DP-700 category - Want to get hands-on? โ†’ Check out Fabric Dojo ๐—›๐—ผ๐˜„ ๐˜๐—ผ ๐—ฒ๐—ป๐—ด๐—ฎ๐—ด๐—ฒ ๐˜„๐—ถ๐˜๐—ต ๐˜๐—ต๐—ฒ ๐—ฐ๐—ผ๐—บ๐—บ๐˜‚๐—ป๐—ถ๐˜๐˜†? - Share your knowledge and experience! Even if you're relatively new to Fabric, or the community, your opinion and experiences are valued here! A great way to earn your first point(s) is to introduce yourself in the thread below ๐Ÿ‘‡๐Ÿ˜€ Thank you for engaging and joining us on this exciting learning journey! ๐Ÿ™ Will
how to purchase microsoft fabric license
Hello, i am still new to microsoft fabric, and i wanted to know is purchasing a fabric license as simple as purchasing a power bi pro/premium license? do i just go to the microsoft 365 admin portal center and purchase a fabric license? are there any specific requirements? thank you!
CSV to Delta Tables
Microsoft Fabric has recently introduced a valuable feature that allows direct conversion of CSV files to Delta tables. This enhancement can significantly reduce ETL iterations and save time. Fabric is consistently adding powerful features and improving day by day. Have you had a chance to explore this new feature? https://blog.fabric.microsoft.com/en-sg/blog/announcing-shortcut-transformations-from-files-to-delta-tables-always-in-sync-no-pipelines-required
1-30 of 551
Learn Microsoft Fabric
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Powered by