Forum Discussion

chintu9494's avatar
chintu9494
Frequent Visitor
2 years ago

Data from another database table doesnt load

Hi Guys,   I connected Power bi to Project Online DB and a SharePoint list by using Project GUID as the unique key. I use Category and Project name from SP List and then when I try to bring the KPI...
General Comment
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi chintu9494 ,

I'm having a hard time determining what the problem is with just the description and screenshots, so please provide some sample data (remember to remove private content). 
If you have all these results calculated by DAX or other means, please provide your code as well.

Best Regards,
Dino Tao

chintu9494's avatar
chintu9494
Frequent Visitor
2 years ago

hI Dino,

 

Thanks for your response, the problem here is that when i join or connect two different tables from different database in this case it is Project Online DB and SharePoint list. when I create a table view in Power BI and use the fields called Category and Project name from SharePoint list (Projects Timeline 2024 Portfolio) and add fields like KPI Overall, KPI Budget, KPI Schedule, KPI Scope from Project Online DB, the data displaying for these fields (KPI's) are not correct, it by defaults displays "GREEN" everywhere. Not sure if this explains the problem. 

P.S I am not using any code or query to extract the data, it is plain simple fields from these two different tables from two different Datasets