Forum Discussion

LuciaTan's avatar
LuciaTan
New Member
3 years ago

Power BI source step reading excel file showing inconsistent format

Hi, I have a monthly power BI report that gets updated each month. It reads excel file which is outputted by SAS. The format of the excel file for different months should be the same. But the query f...
Need Help
rrm121812's avatar
rrm121812
Icon for Helper II rankHelper II
3 years ago

Hi LuciaTan,

 

If you want only Name and Data columns from your data source, you can add a filter step after source which Keeps only these two columns and deletes the rest.

 

If you find this helpful, please Accept this as a solution.