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.
The source is coming from web in csv format
I have tried the following steps to resolve:
- remove Column=42
- rename column headers to lower case
- duplicating column and then perform split
Solved! Go to Solution.
Removed "promote header" command and had to manually re-name all the columns but it works.
Removed "promote header" command and had to manually re-name all the columns but it works.
Hi @Anonymous ,
I'm afraid that the issue should be caused by the step Split columns.
From the query, it seems that the Cost_Center_-_Name wase be changed for Cost_Center_-_Name.1 and Cost_Center_-_Name .2.
After spliting columns, please click refresh and then try to apply and close.
If you still need help, could you share the query which could reproduce the issue so that I could have a test on it?
In addition, please note do mask your sensitive data before uploading.
Best Regards,
Cherry
Hi Cherry,
The data source is web (Workday). While the downloaded csv of the same report works fine but the error results only if the same report is from web source. Unfortunately, I am unable to share the web report access.
I have also tried duplicating the column and then split the duplicate column but even after that, same error exist "the table wasn't found" while I could see the same column on the file.
many thanks,
Manan
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |