Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Edit Dataset

Hi all,   I'm wondering if there is a way how I can edit a dataset like using the Power query, for example. When I connect to the dataset with Power BI Desktop, the only option that I have is creat...
Need Help
Show and Tell
PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Anonymous Did you mean - How to transform/Edit the source data after it was imported into Power BI Desktop ? Is that you are looking for ?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes, I think so. I have a dataset in the Power BI web. I can open that dataset with Power BI Desktop (Get Data - Power BI datasets), the dataset is uploaded to the Desktop with all tables and columns but I can't transform/edit this dataset. 

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    Anonymous Unfortunately, you can't edit the "Datasets" that are imported from "Power BI Service". You need to import the dataset directly into "Power BI Desktop" to transform the dataset and then publish to the PBI Service.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      That's really unfortunate.. Anyway, thank you for the response! Will try to seach for other options..

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      "You need to import the dataset directly into "Power BI Desktop" to transform the dataset and then publish to the PBI Service."

       

      Can you plese explain how this is done?