Everything Power BI: A Complete Overview
We invite you to explore the world of Power BI with this all-inclusive event designed for data enthusiasts, analysts, business analysts, and data professionals. Whether you’re just starting out or looking to refine your skills, this session provides a holistic overview of Power BI’s capabilities, empowering you to transform raw data into actionable insights. From an introduction to Power BI, data integration, and visualization to the Power BI service, this event covers the overview of Power BI's functionalities—possibilities that exist therein. Gain insights into using Power BI to make data-driven decisions, design impactful dashboards, and unlock hidden patterns in your data. Date: Saturday, 25th January 2025 Time: 4pm Format/Venue: Virtual (Microsoft Teams) Fee: Absolutely free (all you need to do is register for the event).Live Community Session This Saturday: Unlock Microsoft Fabric’s Latest Feature
Live Community Session This Saturday: Unlock Microsoft Fabric’s Latest Feature – Mirroring! Join us tfor a power-packed live online session where we deep dive into Mirroring, one of the most exciting new features in Microsoft Fabric! Date: Saturday, May 18th Time: 11:00 AM – 12:00 PM IST Location: Online (Link will be shared upon registration) What You’ll Learn: What is Mirroring? – Understand the fundamentals and why it's a game changer. Mirroring vs. ETL – Learn when to use mirroring instead of traditional ETL. Compatible Databases – Find out what can be mirrored into MS Fabric. Live Demo – Mirror Azure SQL into Fabric step-by-step. Live Demo – Mirror On-Prem SQL Server into Fabric using a practical workaround. Open Mirroring – Explained & Demo – A special segment with Shashank Chhoker on Open Mirroring and its use cases. Presented by: Jitendra Sharma, Senior Technical Architect (15+ years of experience) Shashank Chhoker, Data Scientist, Orange Data Tech Moderated by: Samanvay Gupta, Community Advocate If you're a data engineer, architect, or Fabric enthusiast—this session is not to be missed!
Unlink Microsoft Onelake
Hi everyone. I'm facing an issue when I try to unlink my Dataverse Link to Fabric link. I cannot add new tables, cannot unlink, create a new one. When I try to unlink, it shows this: If I go to 'details', it shows this: And if I go to 'manage tables', I face this error: I know that in all these cases I need to contact the support team, but I'd like to give a shot here before. Any guesses of what could be causing that? I tried to link, unlink, I even deleted the workspace and tried to set up in a new one, but it shows that it already exists: "Your tables are already linked with Microsoft Fabric".
Copilot for Fabric how to get estimates of input tokens for a single request
We are thinking of adopting copilot for our data science team but we want to do some cost analysis before we start using it. So as per the fabric documentation copilot cost depends on the number of input tokens and number of output tokens and both types of tokens consume different CUs. But now the problem is we cannot estimate the input tokens for a single request because as per this blog: "Fabric Copilot Pricing: An End-to-End example", "A single user input prompt can result in multiple requests being sent from Fabric Copilot to Azure OpenAI. As per the example in the blog the prompt; “Load Customers from my Lakehouse into DataFrames” would generate 7 requests to Azure Open AI, with 4,967 input tokens and 227 output tokens." Now I want to understand, how come this single promopt with 7 words consume 4967 tokens. More importantly, how can we estimate that how many input tokens are gonna be consumed for a single request that we send to copilot. Because, as per the example in blog it can be different and it does not only depend on how many tokens are there in user's input.
FOR JSON Path in Fabric Warehouse
Hi, I have noticed that the FOR JSON statement is not supported in Fabric Synapse, and was wondering if there is any alternative to it? I am working on a Stored Procedure that will be used in a pipeline in Data Factory, and one of the things I want the SP to do is to pass several parameters to the next pipeline that will be executed. I have the parameters in table format and have previously in SQL Server turned them into JSON-format with FOR JSON Path-statement, but this is not supported in Fabric. That is why I was wondering if there is a similar statement that is available in Fabric, and if not, what are some possible work-arounds?
How to access Fabric Warehouse from Fabric Notebooks?
Hi, I am trying to access Fabric Datawarehouse table from Fabric notebooks. I am copying ABFS path of Datawarehouse table from its properties as under the hood table in datawarehouse is a delta table. And then passed below query - df = spark.read.format("delta").load("abfss://My [email protected]/test_dw.Datawarehouse/Tables/dbo/Date") It's getting failed with the following error - IllegalArgumentException: Illegal character in authority at index 8: abfss://My [email protected]. I tried passing below query but again same error. df = spark.read.format("delta").load("abfss://My%[email protected]/test_dw.Datawarehouse/Tables/dbo/Date") Just wondering is it possible to read and write to warehouse tables from notebooks in Fabric? We have similar option in Synapse in which we can read/write data warehouse tables using .synapsesql option using Notebooks. https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/writing-data-using-azure-synapse-dedicated-sql-pool-connector/ba-p/3535930Not able to connect to ADLS with shortcut in Lakehouse/One Lake (given all roles, no vnet)
Dear community, I am testing the use case of Fabric for a client of mine, instead of going with the regular Azure SQL Server + Azure Data Factory stack. I have been able to connect sources and push data to the ADLS gen 2, which was originally a blob storage but I have converted it to an ADLS gen 2. I have searched the forums and tried everything. I have given all the roles I could find to be relevant (I am already the Owner but I also gave myself the blob stroage owner, contributor and reader). There is no vnet configured as well. Still, I cannot get the data loaded into the lakehouse in Fabric. I have tried both the dataflow gen 2 (which gives me invalid credentials error) and the shortcut option, which was my preferred option. With the shortcut I am able to connect to the ADLS with my account credentials but then I get the following error: Error 403 - This request is not authorized to perform this operation. What do I need to do to get this sorted? I want to test my use case to see if I can proceed with Fabric instead of the regular Azure SQL tools. Kind regards, Jesper
