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.
Hi All,
I have one PBI file which is working fine for last 2 year , recently unable to refresh since last 1 week.
It take me a lot of time to find out the cause of the problem. why unable to refresh ?
Each time i refresh i will get below error :-
Then i go to PQ editor , after wait for a while to refresh , the error display below :-
I realise the error is cause by PBI last 2 week not load all the field , the last field it load Bill To Country Code.
Below is my Raw data field , it refuse to load last 2 field name ( Stop load from Bill To Country Code ) :-
When i go to advance editor , i edit the script by remove those last 2 field name , now my PBI can refresh :-
So now i seek the expert advise what are the reasons can cause the above issue ?
Hope some one can give me advise. So that when this issue happen again , i know how to sovle it. As this issue will cause another issue , that is this table append to another table. and cause my whole PBI report not working.
Remark :-
1. Raw data i never add or remove field for last 2 year. Meaning not cause by raw data i put at sharePoint.
2. Why when i edit the script by remove load last 2 field , then it work ? In the first place why suddenly it refuse to load all the field ? that cause i need to edit the script.
3.When i create a new PBI file , i load file by sharepoint , and i confirm i can load all field. ( I refer to able to load the last 2 field name ) , why out of sudden my PBI suddenly refuse to load last 2 field ?
Paul
What is the format of your source data? Is it CSV? When you first load a csv, it hard codes the number of columns into the load step. If the number of columns changes later, they won't get picked up later. I suggest you click on the step before the load csv step, then load the csv again. This should retrigger the correct number of columns. Remove the old csv load step.
Thank you for reply my post , appreciate very much.
I have follow your step , it work , it can manage to load all the field.
The above approach is same as i remove the script on not loading last 2 field name. Which i am still not able to know why this happen ? ( As it will need to append the SALES_I table with SALE , i need to manually rename SALES_I field name same as SALES in order to append ). Hope you can other advise to me ?
Paul
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 |
---|---|
107 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |