I have 5 excel workbooks in One Drive. I have 5 individual Power BI reports built off of the excel reports in the same one drive folder. The excel files import to Power BI with no issues. Then when I attempt to bring in the report, I am using "import file" to bring in the reports. When they come in, they generate another duplicate Excel sheet. What am I doing worng, any ideas? Thanks for helping.

Yes, lots of time went itnto 5 reports, so I will try option 2 that you gave to see if that will work. Will elet you know by tomorrow, thanks!

Hi Anonymous ,is this the case?I have completely same data in both options (Tabulka1 and Sheet1).I see here 2 options: One is only my sheet, second is data formated as table. In my scenario, it is one and the same.To be more specific my table (Tabulka1) is part of Sheet1, but it imports same data.

First I brought in the excel files as datasets shown below. Then when I bring in an imported report, it generates a new excel database. The issue I am facing is, so what will the report use on refresh of the data? My imported excel sheets are coming from One Drive, where I want to keep them a safety since I apparently have no idea what I'm doing. The issue I will have is that there are multiple excel files for the same report, sorry to say it is confusing.

Hi Again,I am bit confused so I will try to sum up here:1. You go to PBI Service2. You create a new dataset from One Drive (where you have your 5 Excels, lets say A,B,C,D,E)3. You go to PBI desktop and use datasource as "PBI Datasets", where you use one of those 5 datasets.Question is:The issue I will have is that there are multiple excel files for the same report.Does this mean, you are trying to connect one single PBI Report to more dataset A and B at the same time?

What am I doing wrong- extra excel dataset being created when report is imported

10 Replies

Migasuke
Memorable Member
5 years ago
Hi Anonymous ,

is this the case?
I have completely same data in both options (Tabulka1 and Sheet1).
I see here 2 options: One is only my sheet, second is data formated as table. In my scenario, it is one and the same.

To be more specific my table (Tabulka1) is part of Sheet1, but it imports same data.
- Anonymous
  Not applicable
  5 years ago
  First I brought in the excel files as datasets shown below. Then when I bring in an imported report, it generates a new excel database. The issue I am facing is, so what will the report use on refresh of the data? My imported excel sheets are coming from One Drive, where I want to keep them a safety since I apparently have no idea what I'm doing. The issue I will have is that there are multiple excel files for the same report, sorry to say it is confusing.
  - Migasuke
    Memorable Member
    5 years ago
    Hi Again,
    
    I am bit confused so I will try to sum up here:
    1. You go to PBI Service
    2. You create a new dataset from One Drive (where you have your 5 Excels, lets say A,B,C,D,E)
    3. You go to PBI desktop and use datasource as "PBI Datasets", where you use one of those 5 datasets.
    
    Question is:
    The issue I will have is that there are multiple excel files for the same report.
    
    Does this mean, you are trying to connect one single PBI Report to more dataset A and B at the same time?
Anonymous
Not applicable
5 years ago
Anonymous
Not applicable
5 years ago
No, sorry, the reply and the video didn't help, I apprecaite the support, but don't understand why I now need to put data into sharepoint, when this was supposed to be designed to link to the dataset in my one drive folder. I'll give up for now, you can consider this closed, I just honestly can't say my issue is resolved. the other issue I have is- why can't I do this direct in Power BI, why do I need the desktop. Sorry, I'm ignorant and not very skilled.
- v-kkf-msft
  Community Support
  5 years ago
  Hi Anonymous ,
  
  When you upload a report from OneDrive to the PowerBI Service, the datasets with the same name as the reports will be automatically generated.
  
  The PowerBI Service criterion for judging whether there are duplicate datasets is whether the names of the datasets are the same. In the screenshot of the duplicate datasets that you gave, I did not see that there are some datasets with the same name.
  
  If you want to update the datasets, I'd like you to configure the credentials in the pane shown in the figure below.
  
  If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
  
  Best Regards,
  Winniz
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.