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
Iheb_Ghali
Frequent Visitor

change data source from excel file to database view

hello everyone!!

i have an Excel file (containing data extracted from a view ) used as a data source to develop some reports, now i have to change the data source from the Excel file to that database view, is there any solution to do it without redoing the entire work? Smiley Sad  

 

thanks 

1 ACCEPTED SOLUTION
blopez11
Resident Rockstar
Resident Rockstar

I haven't tried it, but you could bring in your data with the view

Then in the query editor, try to replicate the transformations you've done to the excel file using the Advanced Editor

View solution in original post

2 REPLIES 2
blopez11
Resident Rockstar
Resident Rockstar

I haven't tried it, but you could bring in your data with the view

Then in the query editor, try to replicate the transformations you've done to the excel file using the Advanced Editor

that worked just fine!!

 

thank you very much Smiley Happy

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.