Forum Discussion

Tahech's avatar
Tahech
Helper I
3 years ago

Power BI: How to use Python to access multiple tables?

 

 

I'd like to do something like this inside PBI:

import pandas as pd
import numpy as np

proc = cad_processo
moeda = tab_moeda_data

def name_of_the_function(proc, moeda):
   df = code...
   return df

Now I'll explain more in-depth what I'm doing:

I'm in a table called cad_processo, I need to apply a very complex function to create a column in cad_processo, but in order to create this new column, I need another table called tab_moeda_data.

I tried what was explained in the post I quoted before, but I wasn't able to achieve nothing so far.

In theory it's simple, import 2 tables and apply a function to create a new column, but I'm not being able to import this second table (tab_moeda_data) into the cad_processo to apply the function.

 

 

*I know that cad_processo is called dataset in this case I only need to import another table (tab_moeda_data) to apply the function, that's it.

Can anyone help me?