Forum Discussion

RossChevalier's avatar
RossChevalier
Helper III
5 years ago
Solved

Update Dataset to show added columns in the SQL connection

I have two datasets connecting to the same SQL View via a Gateway Connection using the same gateway.  One of them shows all the columns in the SQL View, and the other does not.  How do I update the d...
  • v-yingjl's avatar
    5 years ago

    Hi RossChevalier ,
    "Is there a way to move a report using one dataset to a different dataset, given that all the columns in use are the same?"

    You should know that a report in power bi service is based on a dataset, a workspace in power bi service cannot have the same dataset but can create many reports based on one dataset.

    If the datasets have the same dimensions and measures, we can switch a report from one PowerBI dataset to another PowerBI dataset, refer this blog.

    In power bi service, we can move a report / dataset from a workspace to another workspace directly, refer this issue.

     

    Best Regards,
    Yingjie Li

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