Can use the same excel source (hosted on sharepoint) to feed different Power Bi Reports

[Anonymous]

Hi Gurus,

Can we use same excel file(on Sharepoint) to feed multple powerBI reports and refresh same time ? Sometime I am seeing forecly the connection is closed errors. Please advice.

Regards

Pulendar

[venal]

@Anonymous 

Case-1:- You can use the same excel file and create different reports, might be "forecly the connection is closed errors".

Case-2:- To avoid the above one, please try to create a dataset with out any visual and use the same one from Desktop and create different reports.

Case-3:- You can use Dataflow, connect it to Desktop and create a different reports.

If you have any concerns, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR,

venal.

[Anonymous]

Thank you Venal,

Case-1:- You can use the same excel file and create different reports, might be "forecly the connection is closed errors".// Anyway to fix this ? As we have complex reports used excel files.

Case-2:- To avoid the above one, please try to create a dataset with out any visual and use the same one from Desktop and create different reports. // Can we use process for multi excel sourced reports or only works for one excel ? 

Case-3:- You can use Dataflow, connect it to Desktop and create a different report // Are there any steps to follow this. 

Regards,

[venal · Accepted solution]

2. Yes, you can multi excel files.

3. Please refer the document.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR,

venal.