Forum Discussion

jPinhao's avatar
jPinhao
Advocate 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
Roshna's avatar
Roshna
Microsoft Employee
10 years ago

Facing a similar issue. Did you find any solution to this?

jPinhao's avatar
jPinhao
Advocate 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.

  • Davieboy234's avatar
    Davieboy234
    New Member
    9 years ago

    Hi JPinhao,

     

    I would be interested in how you solved this issue using R, could you provide me with the details please?

     

    Thanks

     

     

  • cdok1091's avatar
    cdok1091
    Advocate II
    9 years ago

    I'm also interested in dynamically creating query tables using R data frames.  Can you send along the solution?  Thanks!

  • cdok1091's avatar
    cdok1091
    Advocate II
    9 years ago

    Hi, I'm also interested in how you dynamically created data frames in R and uploaded to Power BI.  Could you post or forward?  Thanks!

     

    -Chuck

  • 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