Different report using different Dataset in different Workspace with Same Name

[khush19]

In power BI Service I created two Workspace

• DEV
• SIT

I created PowerBI report using Push dataset from Stream Analytics with dataset set name "RealTimeDataset"

I Published reports to DEV workspace and it is working fine.

Now i deployed it to SIT Workspace where through Stream Analytics i created datset in SIT workspace with same name "Real"TimeDataset"

Now reports in SIT we not pointing to SIT dataset but using DEV dataset.

So ,I disabled the option:

But still my SIT reports are not using SIT dataset.

How to achieve this?

[v-alq-msft]

Hi, @khush19 

I'd like to suggest you refer the following checklist to troubleshoot the issue:

1. Restart the Azure Stream Analytics job (jobs created before the streaming GA release will require a restart)
2. Try reauthorizing your Power BI connection in Azure Stream Analytics
3. Which workspace did you specify in the Azure Stream Analytics output? In the Power BI service, are you checking in that (same) workspace?
4. Does the Azure Stream Analytics query explicitly output to the Power BI output? (using the INTO keyword)
5. Does the Azure Stream Analytics job have data flowing through it? The dataset will only get created when there is data being transmitted.
6. Can you look into the Azure Stream Analytics logs to see if there are any warnings or errors?

For further information, you may refer the document .

Best Regards

Allan

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

[amitchandak]

@khush19 , refer if this can help

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces

[khush19]

I dnt want to use dataset present in different workspace.

I want that when i publish my report it should link to dataset present in workspace where the report is deployed.

[Anonymous]

@khush19  - Did you check at the below sections while configuring the dataset when deploying to SIT workspace, as I see if you are using any parameters to point to DEV in this case even if the dataset is in SIT workspace.

[khush19]

HI,

I am using Push dataset so most of the option(parameters..) is greyed out for me.

For SIT reports to point to SIT dataset I clicked on 

When i clicked it ,it showed me all dataset and i selected dataset for SIT and published my report to SIT Workspace again deleting the already existing reports in SIT which was pointing to DEV dataset