Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 connected using SharePoint:
and another table with employees (includes ratio column from merging the first table and then expanding the ratio column):
When I apply changes to the ratios in the original Excel-Workbook (for an example ratio 15% is changed to 18%). The changes apply in the first table and the second table in Power Query and Power BI Desktop after refreshing the data.
In Power BI Service however, the changes only apply in the first table and NOT in the second even after refreshing. This is frustrating and I need help to figure out how to let the change apply in the second table as well.
Thank you!
Solved! Go to Solution.
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.
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!