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.
I have a data source I am pulling from Google Sheets. One of the columns in the data source is a hyperlink to another Google sheet. Is it possible using power query or power bi to automatically create a new data source from the hyper link and create a realtion between the source and link?
Solved! Go to Solution.
No, Power Query cannot create data sources dynamically. All queries (partititons) and parameters (expressions) must be specified in the section1 portion statically.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com
No, Power Query cannot create data sources dynamically. All queries (partititons) and parameters (expressions) must be specified in the section1 portion statically.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com
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.