Forum Discussion

jPinhao's avatar
jPinhao
Icon for Advocate II rankAdvocate II
10 years ago

Dynamically generate query tables

I'm importing data from an Azure Blob, and then generating some queries to share on the online portal. One of my intermediate queries generates a table of [name][table] like:   Query: ALL TABLES na...
Need Help
jPinhao's avatar
jPinhao
Icon for Advocate II rankAdvocate II
9 years ago

Roshna we now found a solution for this, however it only works at the data loading stage.

 

Using the R connector, you can read your data source and generate data frames dynamically in R, which are then loaded into Power BI. If you want more info on how we did this let me know.

ZacharyW's avatar
ZacharyW
New Member
7 years ago

jPinhao I realize this is an old thread, but would appreciate any insight into how one can achieve this via R. Shoot my way if you can! Thanks greatly