Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created the following calculated columns:
Domestic = if('Shipping Requests'[InternationalShipment]="TRUE",0,1)
International = if('Shipping Requests'[InternationalShipment]="TRUE",1,0)
GrantOrMTA = if('Shipping Requests'[AgreementOrGrantFlag]="TRUE",1,0)
In my report I use Multi-row card to show the sum of each column. I have also tried a visual card for each with the same results.
When 1st publised to My Workspace, the data is correct. It remains correct each time I re-publish from the desk
Then I schedule a refresh and for the momemt keep the underlying data unchanged. Following the refresh the multi-card changes to the following:
I have reviewed the posted troubleshooting refresh scenarios, https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios and do not believe the suggestions provided include my problem.
Any help much appreciated,
Thanks, PaulWo
Solved! Go to Solution.
The calculated columns I described at the start of this thread were created in PowerBI Desktop. I tried moving the creation of these calculated columns to the Power Query Editor. That change eliminated the problem. Not sure why but it worked.
The calculated columns I described at the start of this thread were created in PowerBI Desktop. I tried moving the creation of these calculated columns to the Power Query Editor. That change eliminated the problem. Not sure why but it worked.
The datatable containing the calculated columns is refreshed. It is my understanding the if you schedule a data refresh all Import mode dataset types are retrieved and recalculated. My comment regarding "keep the underlying data unchanged" was to say the data used to sum Domestic, International and Grant | MTA columns did not change.
My auto refresh history appears to be successful -
I appreciate your response. Issue still exists.
I'm not using a gateway connection. All my data sources are in the cloud.
My scheduled refresh should be performing the Power Query Refresh. Other areas of the report update so I do think a refresh query is occuring. Perhaps I don't understand your last comment.
When I refresh on the desktop everything looks good. When I publish to the BI service and review the report on the BI service everything looks good. When I shedule auto refresh from the BI service everything, credentials, access ect looks to be set up correctly. When the scheduled refresh runs the BI service reports the refresh was successfully completed. When I look at the report after the 1st scheduled refresh, the calculated measures I described at the begining of this thread do not display correctly.
I have the same problem. Do you have now a solution for this problem?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |