Forum Discussion

Taher1's avatar
Taher1
Frequent Visitor
3 years ago
Solved

Changes within merges in power query

Hello,    I will try my best to describe my problem:    I have created a report that uses data from multiple sources.    I have a table from Excel with different positions and ratios that I con...
Help Request
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Taher1 ,

    I test it in the Power BI service and Power BI Desktop, the data will change if the "Ratio" change.

    Please try below steps:

    1. if you use the gateway, please confirm you have set the gateway correctly

    2. please confirm all the operations is correct

     

    I have attached my test data source and .pbix file, please refer.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Taher1 ,

I test it in the Power BI service and Power BI Desktop, the data will change if the "Ratio" change.

Please try below steps:

1. if you use the gateway, please confirm you have set the gateway correctly

2. please confirm all the operations is correct

 

I have attached my test data source and .pbix file, please refer.

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Taher1's avatar
Taher1
Frequent Visitor
3 years ago

Hi Anonymous,

 

I tested it with your dataset and it worked. I think the problem is because of the data source credentials. 

 

At first, I had a trouble setting the credentials but then I just skipped the connection test. I am using workato to pull my data from a data source on cloud using an API-TOKEN. Do you know what kind of credentials could work to connect this data source properly? 

 

Best regards,

Taher