Forum Discussion

khush19's avatar
khush19
Resolver I
6 years ago

Different report using different Dataset in different Workspace with Same Name

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?

5 Replies

    • khush19's avatar
      khush19
      Resolver I

      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's avatar
        Anonymous
        Not applicable

        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.

         

         

         
  • v-alq-msft's avatar
    v-alq-msft
    Community Support

    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.