Forum Discussion
New Get Data leaving me stranded - can't create reports!
The new experience of creating a new report starting with Get Data is just resulting with a new Excel file on the Workbooks tab in My Workspace. All the documents I've found online and books I have show the result of "getting data" should be a new report or dataset being created. I can't find any way to create a new report from an Excel file that has been imported online so I'm really stuck.
5 Replies
v-frfei-msftCommunity Support
Hi Anonymous,
Did you get data in Power BI service? By that way, You cannot create a normal report. When you choose Connect, your workbook will appear in Power BI just like it would in Excel Online. You can refer the document here.
https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files
You can only get data using Power BI desktop, Please check the online document.
Regards,
Frank
Sorry, but the article you linked to would do exactly what I need to do but the experience in the BI service doesn't match what is documented anymore. If you "get data" in the service, the docs state that once it's been uploaded it can be found under Reports or Datasets. Neither is the case anymore, it's only showing up under Workbooks. I'm dead in the water when it comes to my Excel files. Performing get data on a CSV file however, does result in a new report and dataset being created. This is really frustrating because I can't even find where these workbooks are being saved - OneDrive? SharePoint?
nirvana_mokshImpactful Individual
I replicated what you are trying to do and it works as intended, importing a csv got the same file named dataset and also allowed me to create a thereof. If you have a multi-tab excel I believe PBI Service would give you an option which says import data or upload file.
- v-frfei-msft
Hi Anonymous,
I tested it again by uploading an excel file. You can refer to the step as below.
1. get data - local file - upload
2. Then you can find it in Workbooks and datasets. Also you can use the dataset to create reports as well.
Regards,
Frank
- v-frfei-msft
Hi Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank