Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Minniemish
Frequent Visitor

Can you edit Dataset in Power BI Service for changes to the data source?

I have a dashboard that was created in Power BI service from a dataset imported into the workspace from a sharepoint list. The format of the sharepoint list has now changed and I am unable to refresh the data set due to missing columns. In Power BI desktop I would edit the query code to recognise the new or deleted columns - can something similar be done in Power BI service? 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @Minniemish 

 

Unfortunately you have to do this in Power BI Desktop and then upload the changes.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
Migasuke
Super User
Super User

Hi @Minniemish ,

Editing dataset for example the same way as you do in Power Editor is not possible. What you can do (at least in future set ups) you can use advantage od Datamart or Dataflow. Those two services allow you to do some modeling.

 



If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

Minniemish
Frequent Visitor

Thanks @GilbertQ I've only just realised I can export dashboards created in service back to desktop and edit there 🙂

GilbertQ
Super User
Super User

Hi @Minniemish 

 

Unfortunately you have to do this in Power BI Desktop and then upload the changes.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors