Forum Discussion
Change data source for all tables
Hi admin_xlsior ,
Normally, there is no change data source option for the data source under Global Permission.
Do you see this for your client pbix?
If you have the same scenario like above, I'm afraid the data source is created by Enter Data in Power BI so you cannot see it. However, you could see it in Edit Queries >>Advanced Editor.
You could change the data source in Advanced Editor manually. Please note if you want to change the data source, you'd better check if the tables format(e.g. column name,column type, numbers of columns) are same. If the tables format are different, it will return errors.
Best Regards,
Cherry
Hi Cherry,
It is last month edition -> 2.69.5467.2151 64-bit (May 2019)
Yes, I do look into Global Permission since I didn't see my data source with option Data source in this file. (I get the PBIX from my client). As mentioned, I can see it in Global Permission, but there is no button Change Source in below bar, nor if I right click.
Thanks,
Hi admin_xlsior ,
Normally, there is no change data source option for the data source under Global Permission.
Do you see this for your client pbix?
If you have the same scenario like above, I'm afraid the data source is created by Enter Data in Power BI so you cannot see it. However, you could see it in Edit Queries >>Advanced Editor.
You could change the data source in Advanced Editor manually. Please note if you want to change the data source, you'd better check if the tables format(e.g. column name,column type, numbers of columns) are same. If the tables format are different, it will return errors.
Best Regards,
Cherry
Hi Cherry,
I am not sure the question was fully answered. When changing the data source from Advanced Editor, is there a way to change the data source for all tables at once rather than having to do one table at a time?
