MSBI Tutor

We’ve also been working hard to ensure that all Microsoft 365 update channels are able to use this feature in the Excel desktop application. Insert a connected table in Excel online To connect directly to data in your semantic model: Select  Data from Power BI  on the  Data  tab of the ribbon Use the  search feature  in the Power BI Datasets pane to find the dataset/semantic model you’d like to connect to and select  Insert Table Use the  Create Table  dialog to: Select data to appear in your table in the  Data pane Apply any filters you’d like in the  Filters pane Rearrange the field order in the  Build pane Select  Insert Table . You now have a table connected directly to your Power BI semantic model. Just like with other Connected Table experiences, the workbook contains a connection that you can review and modify in the Queries and Connections properties. Updates to the Excel desktop application We have a quick update ...

We are excited to announce that Mirroring, previously announced at Ignite in November 2023, is now available to customers in Public Preview. You can now seamlessly bring your databases into OneLake in Microsoft Fabric, enabling seamless zero-ETL, near real-time insights on your data – and unlocking warehousing, BI, AI, and more.  Data driven insights are important for  every  business. With the critical need to make smart decisions, create new things, improve your products or services – time to value is everything. Yet, this can be difficult when you have data in different places, like apps, databases, and data warehouses. These places typically store data differently, so you can’t easily analyze and cross reference them – you have to laboriously move their data to a place where you can analyze and harmonize at scale. Doing this takes time, money, and typically, costly expertise to build complex, connected solutions. By the time you do this your data is old, and your in...

We are pleased to announce the ability to  use the Get Data   experience and  connect to  100+  data   sources such as Snowflake,  Databricks and AWS Redshift from Power BI Report Builder. You can  transform the data and select the M-Query to be used for the   paginated  report.  All you need is the latest version of Power BI Report Builder  Install Power BI Report Builder   from the Microsoft Download Center.     For this blog, we are creating an NYC Taxi Report paginated report with data in a Snowflake backend. To do this, l aunch Power BI Report Builder and navigate to the “Data” tab. Select “Get Data” from the toolbar.   This will launch the “Get Data” experience. You can search for the data source that you want to connect to or  “ View more ” .   For this blog, I selected a  S nowflake  data source.  Enter the server, warehouse  and,   credentials . You can use organiz...

We are thrilled to announce the public preview of our new Excel and CSV data connectors for creating Power BI reports in Fabric. This new feature is a significant milestone in our ongoing commitment to providing the most comprehensive, unified, and user-friendly cross-platform experience for Power BI users. By integrating Excel and CSV file support directly into the report creation experience in Fabric, we are streamlining workflows for data analysts and other information workers while making it easier than ever to access, analyze, and collaborate on data. Key Features of the New Data Connectors The new Excel and CSV data connectors are designed with flexibility, efficiency, and ease of use in mind. Here are some of the key features: Direct Import : With just a few clicks, you can now import Excel and CSV files directly from OneDrive or a local computer folder (via OneDrive) into their Fabric workspace. This eliminates the need for intermediate storage or conversion steps, significantl...