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.
Hello BI Community,
I need help building visuals when no dataset is created in BI Service. When connecting to an excel file on One Drive for Business I selected "Connect, Manage and View" to use the existing tables and formulas in the excel file. After connection was complete I can see the workbook but there no corresponding dataset. A little confused becasue I thought that a dataset would automatically be created. I think I'm overlookig something fundamental.
How can I build visuals when I only have a workbook with no dataset?
Thanks!
Joe
Solved! Go to Solution.
Hi @Joe_Short,
When you get date using "Connect, manage and view Excel in Power BI", your workbook will appear in Power BI just like it would in Excel Online. When choosing this way, no dataset is created in Power BI. So if you want to use the data in excel to create report/visuals, you need to Import Excel data into Power BI.
When you have created reported in excel, and want to pin the report to dashbord, you can use the way of "Connect, manage and view Excel in Power BI". More details, please review this article: Get data from Excel workbook files .
Best Regards,
Angelia
Hi @Joe_Short,
When you get date using "Connect, manage and view Excel in Power BI", your workbook will appear in Power BI just like it would in Excel Online. When choosing this way, no dataset is created in Power BI. So if you want to use the data in excel to create report/visuals, you need to Import Excel data into Power BI.
When you have created reported in excel, and want to pin the report to dashbord, you can use the way of "Connect, manage and view Excel in Power BI". More details, please review this article: Get data from Excel workbook files .
Best Regards,
Angelia
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.