Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I will be building out reports using Hive and in about 3 weeks they will be moving to cloud.
In powerBI is there a way to just point to the data source isntead of loading the tables?
I will also be performing advanced calculations on the column and adding/deleting columns. Is there a possiblity to just replace the data source later?
Solved! Go to Solution.
Hi @Anonymous,
>>In powerBI is there a way to just point to the data source isntead of loading the tables?
I'm not so sure what you mean, can you please explain more detail. If you mean import data to power bi query tables, you can try to use directquery or live connection mode, they not real import data to power bi side.
>>I will also be performing advanced calculations on the column and adding/deleting columns. Is there a possiblity to just replace the data source later?
I'd like to suggest you can refer to following blog which told about use query parameter to achieve dynamic change data source on power bi service side:
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,
Notice: you should confirm these data sources has same data structure, current query table not support dynamic table structure.
Regards,
Xiaoxin Sheng
Hi @Anonymous,
>>In powerBI is there a way to just point to the data source isntead of loading the tables?
I'm not so sure what you mean, can you please explain more detail. If you mean import data to power bi query tables, you can try to use directquery or live connection mode, they not real import data to power bi side.
>>I will also be performing advanced calculations on the column and adding/deleting columns. Is there a possiblity to just replace the data source later?
I'd like to suggest you can refer to following blog which told about use query parameter to achieve dynamic change data source on power bi service side:
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,
Notice: you should confirm these data sources has same data structure, current query table not support dynamic table structure.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |