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

[Anonymous]

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.

[Anonymous]

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]

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.

[Anonymous]

[Migasuke]

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]

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]

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]

Hi Migasuke, thanks for helping!  No, I am likely just doing something wrong.

1. I created a dataset in Excel and stored in One Drive. 
2. I then created a report in Power BI desktop, and saved to One Drive- the same folder where the dataset is stored
3. Next, in our power BI folders, I imported the dataset from one drive to the workspace (screen 1 below)
4. Next, I imported the already created PBIX report from One Drive into the same Power BI workspace (screen 2 below)
5. When the report comes in to Power BI, it is generating a new excel sheet (see thrid screen).

The questions are- why do I need two, I thought it was supposed to auto connect to the one, and which one do I keep?  I want to update the data set in the one drive folder and have it refresh in power BI and also refresh in the report.  Maybe I have forgotten (have not done this in a few months) and am getting some sequence or step wrong….

Added datasets- from One Drive to Power BI

Added reports- imported from One Drive to Power BI, and built a summary dashboard-

Datasets in Power BI are now showing duplicates-

[Migasuke]

Okay I think I know where the problem is.

There are two options how to proceed:
FIRST (recommended if you havent really spend time on building your PBIX files and you can do it from a scratch)

1. Upload your Excel (for example Excel A) from onedrive to PBI service as a new Dataset:

2. Open a PBI Desktop and choose connect to datasets:

3. Choose the dataset you have in your PBI Service (from Excel A)
4. Customize your report as you need.
5. Publish to the PBI Service. (This will not create a new duplicated dataset).

Flow of the data is like this:
Onedrive -> Power BI Dataset -> Power BI Report

SECOND
(If you already spent lot of time with your reports and just want to avoid duplicities of Datasets, unfortunatelly bit long to describe all steps here, so I will just summarize it)
1. First you need to create a new connection in your report. Connecting to OneDrive via SP folder connection. (https://www.youtube.com/watch?v=cxRacjMb47I)
2. This connection should replace the old connection to the onedrive.
3. Apply your adjusted PQ and save the report.
4. Publish your new report to PBI service. At this point you will see only one dataset (ofcourse if you deleted the old copies)

Flow of the data is like this:
Onedrive/Sharepoint -> Power BI Report

[Anonymous]

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!

[v-kkf-msft]

Hi @Anonymous ，

Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.

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