metadata
4 TopicsPrototyping and Deploying a data warehouse in Fabric using only metadata
Prototyping and deploying a data warehouse in Microsoft Fabric using only metadata enables rapid and automated development without manual coding. Instead of building tables, dataflows, and pipelines manually, you define the structure, relationships, and transformation logic as metadata. Microsoft Fabric reads this metadata to automatically generate the necessary data warehouse components, ensuring consistency and reducing errors. This approach allows for easy iteration, version control, and quick adaptation to business changes by simply updating the metadata. As a result, it accelerates delivery, simplifies maintenance, and provides a scalable, low-code solution for data warehousing. Speaker : Gustavo Leo Specialized in Power BI, Data Modeling, and Data Warehousing, offering over 10 years of experience in the industry Organizers: Rajendra Ongole, Navya, Koundinya Lanka,Shashi 🔗𝑹𝒆𝒈𝒊𝒔𝒕𝒆𝒓 𝒂𝒕 𝑴𝒆𝒆𝒕𝒖𝒑: https://www.meetup.com/dataanalyticgroup/ 📲𝑱𝒐𝒊𝒏 𝒕𝒉𝒆 𝑾𝒉𝒂𝒕𝒔𝑨𝒑𝒑 𝑮𝒓𝒐𝒖𝒑: https://chat.whatsapp.com/CkMRYzyoKSNKbXUs2IN2MU 📲𝑱𝒐𝒊𝒏 𝒕𝒉𝒆 𝑾𝒉𝒂𝒕𝒔𝑨𝒑𝒑 𝑪𝒉𝒂𝒏𝒏𝒆𝒍 𝑳𝒊𝒏𝒌:https://whatsapp.com/channel/0029VaBgfAwDOQIeuTjGbF3u 📲YouTube channel: https://www.youtube.com/@Dataanalyticgroup 🌐 𝑱𝒐𝒊𝒏 𝒖𝒔 𝒐𝒏 𝑭𝒂𝒃𝒓𝒊𝒄 𝑪𝒐𝒎𝒎𝒖𝒏𝒊𝒕𝒚 : https://community.fabric.microsoft.com/t5/Data-Analytic-Group/gh-p/DataAnalyticGroup 🔗 𝑨𝒍𝒔𝒐 𝒂𝒗𝒂𝒊𝒍𝒂𝒃𝒍𝒆 𝒐𝒏 Discord: https://discord.gg/CGvZ2Nu9102Views0likes0CommentsList all Data Sources in all published PBIX files
Hi folks, I'm looking for a way to list all data sources used in all Power BI reports on the Report Server. So far I have not been successful, and I've even looked at the report server tables. Has anyone done this or have ideas? Looking for a native solution, not 3rd party tools, and I would prefer to not have to implement yet another process just to capture this information. Thanks, ShaneSolved12KViews0likes4CommentsCant get SQL queries from PBI Report Server database
Hi experts, I am trying to find SQL queries wihch are the source of the micro data for the PBI reports storred in ReportServer database. I found this conversationWhere Can I find the published report in PowerBI Server usefull, but does not cover all my needs. Does anyboady know how to convert ReportServer.dbo.CatalogItemExtendedContent.Content field where ContentType='CatalogItem' to get the data source SQL queries or how to change powershell script from Anonymous in link above to get the content of the DataMashup file from the PBI.zip file? Thanks in advance, Jerneja1.2KViews1like0Commentsdbo.SubscriptionsHistory table depuration
Hi! We were looking for metadata information in the ReportServer database to obtain the history, length and status of schedule refresh processes. We discovered the "dbo.SubscriptionsHistory" table. However, there's a weird behavior: in DEV server, the table contains the entire history since installing; in PROD server, the table only contains the last 10 days. Is there any configuration that we can move (either at instance or database level) to let the table keep more history days? Regards!Solved2.7KViews0likes4Comments