We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hello
I have a simple question, I want to create a report from 4 different Excel workbooks, those are located in Sharepoint, is the any limit for the report to have connections for differents Excel files, I ask because later this report is going to the Services and I want to have a schedule refresh.
Thanks in advanced
Harrinson Atehortua.
Solved! Go to Solution.
Hi @Anonymous,
For Excel files located in on-premises SharePoint site, after publishing reports to Power BI Service, you would need to add each excel data source under on-premises gateway.
For Excel files located in SharePoint Online, you don't have to configure gateway for data source. The dataset will be updated automatically.
Regards,
Yuliana Gu
Hi @Anonymous,
For Excel files located in on-premises SharePoint site, after publishing reports to Power BI Service, you would need to add each excel data source under on-premises gateway.
For Excel files located in SharePoint Online, you don't have to configure gateway for data source. The dataset will be updated automatically.
Regards,
Yuliana Gu
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 57 | |
| 38 | |
| 32 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 66 | |
| 66 | |
| 40 | |
| 34 | |
| 25 |