cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shamsbutt
Helper II
Helper II

Change Data set of Power BI Live (Stream Analytics)

Hi Everyone,

 

I'm using Power BI pro license and Azure subscription. Scenario is I've to create live reports and Dashboards for my multiple clients by using stream analytics. 

On Azure i have created an event hub and Stream Analytics query and set the out to Power BI, lets say output named as client_1_output(column1, column2, column3).

Now, by using Power BI Desktop data source Power BI Data Set as shown in below image, i can access the data and start the report development. Similarly, i've created another stream analytics output with different name but with same columns and types. Lets say output named as client_2_output(column1, column2, column3).

I want to use same report for my 2nd client. 

 

Live Data Source.png

 

 

 

 

 

What i have tried, change the data source by going to Edit Queries -> Data Source Setting and pick the client 2 data set. but getting error by changing data source. If i revert back to my previous dataset it works fine.

 

client_1_output

Live Data Source2.png

 

 

 

After changing the data source getting error

Error.png

 

 

Error Message
This visual contains one or more filters with deleted columns, type mismatches, or other breaking modeling changes.

Error2.png

 

 

And i've double checked there is no data type mismatch.

Please Help!

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Shamsbutt ,

 

Have the visual been created before you change data source in live connection mode? Please remove all the visuals which have been created previously and create those visuals again after you change the data source. 

 

In addion, please also make sure power bi desktop has been updated to the latest version.

 

Community Support Team _ Jimmy Tao

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

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@Shamsbutt ,

 

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

 

Regards,

Jimmy Tao

v-yuta-msft
Community Support
Community Support

@Shamsbutt ,

 

Have the visual been created before you change data source in live connection mode? Please remove all the visuals which have been created previously and create those visuals again after you change the data source. 

 

In addion, please also make sure power bi desktop has been updated to the latest version.

 

Community Support Team _ Jimmy Tao

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

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors