PowerBI Refresh Error

[Sachit]

Hi Everyone,
Hope you are doing well.

My PowerBI is connected to online Dyamics 365 portal. While refereshing the PowerBI manually, I am getting the below error.
Can someone please suggest a work around.

Thanks in advance! 

[Anonymous]

Hi @Sachit,

Any update for your scenario? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous]

HI @Sachit,

According to the error message, it seems like a common data structure does not match issues. Have you applied any data structure changes to your data source?  If that is the case, you need to manually check these query steps to fix the data structure not match issues.

Notice: power query tables will cache the data structure into the query steps, if the new data structure does not match with these cached old structures, it will show the error about 'key not match' and break the refresh operation.

Regards,

Xiaoxin Sheng

[Pragati11]

Hi @Sachit ,

Looking at the error, the load for other tables was cancelled due to the error 'n the table at the top for which the error is not complete in your screenshot.

If I try to read the inclomplete text, I can see that there is some column missing in the table (can't see the name as the screenshot is incomplete).

I would suggest, checking the datasource and making sure you have all the columns in the tables in portal which were used in Power BI.

Look for the highlighted error:

Thanks,

Pragati

[amitchandak]

@Sachit , First Load PO_subsidaires. Right click on table and refresh. and check if the error is because of time or is it because of some data type error etc.

There were few issues reported - https://community.powerbi.com/t5/Issues/idb-p/Issues