Solved: Operations On Live Streaming Data

GovindPrajapat · ‎07-30-2023

I am using PowerBI Dataset to create a report. This powerBi dataset is coming from Azure Stream. The new coloumn, Table and Data Transformation features are not available for me on this live streaming data.I want to perform some index based operations on this dataset. But I dont have a facility to add index on this dataset. Now how can I achieve this??

Anonymous · ‎08-03-2023

Hi @GovindPrajapat ,

Since you are connecting to Power BI dataset, that is a live connection mode. And you can't see Data view and make transformations(include add index column, append etc.) in Power Query Editor. You can consider to add the index column in the underlying data source. Please find the details in the following links.

Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Learn

Power BI Connections: Live Connection

Best Regards

View solution in original post

Anonymous · ‎08-03-2023

Hi @GovindPrajapat ,

Since you are connecting to Power BI dataset, that is a live connection mode. And you can't see Data view and make transformations(include add index column, append etc.) in Power Query Editor. You can consider to add the index column in the underlying data source. Please find the details in the following links.

Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Learn

Power BI Connections: Live Connection

Best Regards