Forum Discussion
Excel table add to data model and Power BI automatic refresh?
Hi, I have an Excel file with some tables in it. these tables has been added to the data model (Power Pivot) into my Excel document. I save this document in SharePoint and connect it to Power BI o...
I know it
but its not an option.
the file and the powerbi reports & dashboards are in a apps in powerbi shared within the company.
we cant use the personnal gateway to maintain it.
Willgart,
You can use on-premises gateway instead of personal gateway. It doesn't support to automatically refresh your dataset in your original scenario.
Regards,
Lydia