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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors