Power BI Desktop Tips and Tricks (14/100) - Change Data source

[@zahiruddin2835]

I liked your simplicity!!!

[@AnalyticswithNags]

Welcome

[@tlee7028]

does it update the relationships as well?

[@AnalyticswithNags]

Yes

[@ckhara]

Is this method just for more data? What if there are more columns or changes in the column header?

[@AnalyticswithNags]

This is with same dataset means column header are same. In case columns are different that will be treated as individual table

[@ckhara]

@@AnalyticswithNags any workaround for different column header or more columns in new data due to change in application/software/ERP package? Thanks

[@cmlibin]

getting an error as "The key didn't match any rows in the table" for oracle source data while switching from test to Live.

[@Saddam.H703]

I have changed to data source eith new file.. however it is not showing all the rows. It has 6 rows butbonly showing 5. Please help.

[@AnalyticswithNags]

Check in power query you have deleted top 1 rows

[@sourabhpatel3834]

Can we use parameters

[@AnalyticswithNags]

That is the best practice. Soon I will make a video on this

[@jagadishreddy5693]

Happy for your videos sir, but in this video while changing the data source, how it come with same graphs. is it with same columns with updated data or you changed total file ?

[@AnalyticswithNags]

It should be same Column and datatype....

[@rajanpraveen4321]

Hello, how to change SQL server file path in power bi desktop?

[@AnalyticswithNags]

Check datA source type video

[@faiz.ahmad65]

How to change sql server to Excel. I have same data in Excel instead of sql

[@AnalyticswithNags]

Check another video change data source type

[@kartikdubey1858]

How we can convert Qliksense project into Power BI?

[@AnalyticswithNags]

Not sure

[@michaelamare1139]

Great!

[@AnalyticswithNags]

Thank you! Cheers!

[@jeyakumarchinnaraju1154]

Ur every lesson is new things for me. So pls dont give up to stop teaching us.

[@AnalyticswithNags]

We are doing video for people like you..you have hunger to learn new things... Keep Learning. Will continue our work.

[@jeyakumarchinnaraju1154]

Keep doing bro

[@AnalyticswithNags]

Join our group...to get instant clarification on any analytics related queries chat.whatsapp.com/FzPDzFs4Cd09ANEhi0vu9B

[@MrAmrut00]

​@@AnalyticswithNags this link seems to be reset. Can you please share new group link?

[@MrTejasreddy]

Nice 👍

[@AnalyticswithNags]

Thank you! Cheers!

[@ramnagadipudi3002]

Sir, please help me to create capability report using power bi

[@AnalyticswithNags]

explain in details please

[@BKGroups]

If we change data source It is not impact on visual values

[@AnalyticswithNags]

Yes. The data on visuals will change. Usually , you develop based one file(sample file) or database then there might be situation you need to use different file/ database with data updated in that case you will go for it.

[@vikasmhaskar82]

thanks

[@mansoorshaik7263]

This is not how you switch the data source

[@AnalyticswithNags]

This is changing different source. You may looking for changing data source type explained in the video link. kzbin.info/www/bejne/rISplouebqiIaac