Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Data source Issue

Hi, 

Datasource for my report is a dataset, but when I download and view in local it is showing database as data source.

 

What could be the exact error here ? Why am seeing 2 different data source( Different in workspace and power bi desktop)

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

I think you may have misunderstood the concept of dataset. In PowerBI Service, a dataset is a collection of datasource that you import or connect to in PowerBI Desktop.

 

In the PowerBI Desktop, you can connect multiple data sources (excel, csv, database, web, powerbi datasets ...) and even can integrate them into the same query. But once you upload the reports to the service, they will only be found in the same dataset . Similarly, when you download pbix from the service, you can see the data source information  used to create the report in the report.

 

You can refer to these links.

https://community.powerbi.com/t5/Service/Difference-between-data-source-and-data-set/m-p/531191 

https://docs.microsoft.com/en-us/power-bi/fundamentals/service-basic-concepts#datasets 

 

Best Regards,
Community Support Team _ Eason

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

I think you may have misunderstood the concept of dataset. In PowerBI Service, a dataset is a collection of datasource that you import or connect to in PowerBI Desktop.

 

In the PowerBI Desktop, you can connect multiple data sources (excel, csv, database, web, powerbi datasets ...) and even can integrate them into the same query. But once you upload the reports to the service, they will only be found in the same dataset . Similarly, when you download pbix from the service, you can see the data source information  used to create the report in the report.

 

You can refer to these links.

https://community.powerbi.com/t5/Service/Difference-between-data-source-and-data-set/m-p/531191 

https://docs.microsoft.com/en-us/power-bi/fundamentals/service-basic-concepts#datasets 

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.