Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have connected to an excel sheet in onedrive folder from Power BI. Extracting the first column from the excel sheet worked. When I added the second line to extract the second column , thats when I got the error.
Source = Excel.Workbook(Web.Contents("")
#"345_Sheet" = Source{[Item=Source{0}[Item],Kind="Sheet"]}[Data],
#"346_Sheet" = Source{[Item...
Data is very simple. I have an excel sheet with 2 columns. I created some sample data to see if this can be extracted to display on the PBI dashboard.
Hi @nvalPBI
Can you show some sample data?
The links provided do not work
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Looks like data wasnt refreshed. After refreshing the data I get this error now trying to read the second column
Hi @nvalPBI - the following code does not look right:
= Source{[Item=Source{1}[Item],Kind="Sheet"]}[Data]
The following is expected:
= Source{[Item="SheetName",Kind="Sheet"]}[Data]
I think the inclusion of the following code results in the selection of Table object (i.e. Kind="Table"). Note that {1} will return the second row of table because the index starts counting from 0.
= Source{1}[Item] //Returns name of a table not the name of Sheet - is "Table1" the name of this table?
Or this:
= Source{[Item=Source{1}[Item],Kind="Table"]}[Data]
P.S. you might try change to use SharePoint.Files - Wink!
Since the fist column was retreived using the code
Source{[Item=Source{0}[Item],Kind="Sheet"]}[Data]
I thought the second column should be Source {1}. How do you refer to a second colum in a table?? Yes, it is Table1
There is no change in the worksheet and table from first column to second column. Everything same except the columns.