3
2 Topics
Using Excel work book from Share point- Advise needed
Hello, I need an advise on this requirement. I have an excel work book in sharepoint and I need to create a SQL table with the work book as data source. Some of the fields from the work book will be joined to an existing SQL query before use. I intend to download the work book from share point and use it as data source. I am not sure if any change that happens on sharepoint will reflect on the local copy I want to use as data source. If I can use the local copy it solves my problem. Your advise is neededSolved1KViews1like2Comments
Report Server gateway requirement
Hello, I am using import mode to get data from my SQL in shared folder. The SQL are from materialized views and the reports will be published in the report server from Power BI Desktop. My question is do I need a gateway to refresh the data in report server?Solved785Views0likes1Comment