Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have uploaded an Excel Workbook to a Power BI workspace. This wrokbook has a pivot table that is connected to an on-prem Tabular instance. The workbook opens fine in our on-prem SharePoint but I would like for the workbook to live in the Power BI workspace alongside the Power BI reports so that end users can go to one place for all of the reporting and analytics on the subject. However when I upload the workbook and try to refresh it I get an error. I have a data gateway connection setup for this data source (it is the same as the pbix file that is also in the workspace). Has anyone encountered this issue? If so, how did you fix it?
Hi @Anonymous,
I'd like to suggest you upload this excel workbook to sharepoint online and install a personal gateway to handling refresh operation.(power bi service get data from sharepoint online)
According to your error message, it seems like on-premise gateway not works for your scenario.
Regards,
Xiaoxin sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.