cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
anshul18 Frequent Visitor
Frequent Visitor

New column for a streaming Dataset

Hi All,

 

I have a streaming dataset and a report built on top of it. The data definition for data set is as below:

1. TimeStamp (Type = DateTime).

2. ValueType (Type = Text).

3. Value (Type = Number).

I wish to add time (in hours, say 10 hrs) to the field TimeStamp and then display it in the report.

However, it appears, we cannot create a new column when the source for a report is an existing dataset (In this case, a streaming dataset). I am not sure if it is really feasible. Any insights to cater the scenario will be really helpful.

 

Regards

3 REPLIES 3
Community Support Team
Community Support Team

Re: New column for a streaming Dataset

Hi anshul18,

 

According to your description, did you mean you want to add a new column in stream dataset which exists in report? I test this in my environment, it will work well. You could add new rows in streaming dataset like below

77.png

Then you need to re-run the query in powershell. Then if you want to add new field in report, you might will get the error like below

78.png

You  need to click refresh(you might need to click many times) to get newest data, then it will show correctly

79.png

I use powershell  to get data, you could refer to Create a Power BI streaming dataset for real-time dashboards and demo-files/video demos/PowerShell/ for details

Best Regards,

Zoe Zhi

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Community Support Team
Community Support Team

Re: New column for a streaming Dataset

Hi anshul18,

 

Did this help you solve your issue? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

 

Best Regards,
Zoe Zhi

anshul18 Frequent Visitor
Frequent Visitor

Re: New column for a streaming Dataset

Hello,

 

Thanks for your response. We actually wanted to create derived columns in PBI for which the source of data is streaming data set. We have recently learned, that this is actually not possible becasue creating a derived column will in effect require change in data set (PBI data set) - Which is not technically allowed.

 

Thanks again for taking out time and sharing your thoughts.

 

Regards

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 59 members 1,097 guests
Please welcome our newest community members: