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.
On page https://msdn.microsoft.com/en-us/library/mt260859.aspx the definition of Excel.Workbook has 2 parameters. In the code generated by PowerBI the function has a third parameter. More specifically, the second is always "null'", the third one is "true".
As a test I removed the "null" second parameter and now the tables loaded with the first line promoted as header, exactly as the second parameter is supposed to do.
What happened here? Does PowerBI generate incorrect code or is the definition page wrong or ?
Thanks in advance for your answer
Solved! Go to Solution.
The MSDN documentation is somewhat out-of-date. The best place to find up-to-date documentation is in Power Query or Power BI Desktop itself. Inside the query editor, if you enter the formula
= Excel.Workbook
you will see the most recent documentation for that function.
Best Regards,
Herbert
The MSDN documentation is somewhat out-of-date. The best place to find up-to-date documentation is in Power Query or Power BI Desktop itself. Inside the query editor, if you enter the formula
= Excel.Workbook
you will see the most recent documentation for that function.
Best Regards,
Herbert
Hi @FrankHazel,
I can report this issue internally, will update to you once get feedback.
Best Regards,
Qiuyun Yu
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 |
---|---|
101 | |
52 | |
21 | |
12 | |
11 |