Forum Discussion

birdie29's avatar
birdie29
Icon for Advocate II rankAdvocate II
10 years ago

'Enter Data' Limitation

Hi Everyone   I have a Power BI report using a dataset that connects to data via Analysis services, SQL Server and an excel file.   My issue is that I cannot use our company data gateway which af...
Need Help
birdie29's avatar
birdie29
Icon for Advocate II rankAdvocate II
9 years ago

Anonymous Thanks for your quick reply! I must be honest I didn't set up the gateway our IT Systems Manager did but it is a OPDG connection. They are both great suggestions so I'm grateful for your solutions.

 

I suppose my only reservation is that I would like to be able to control the excel connections myself so it's easier for me to chop and change how the data may look, hence my desire to be able to use the 'Enter Data' function. The reason being Power BI reporting is only just getting started where I work so the requests are constantly changing.

 

Thanks again for the help!

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi birdie29,

What is the exact issue when you add data source for Excel file under gateway? When you have multiple data sources (SQL Server, SSAS, Excel) in a dataset, and put excel file on OneDrive , you can utilize personal gateway to schedule refresh for your dataset. For more details, please review the following similar thread.

http://community.powerbi.com/t5/Integrations-with-Files-and/Unable-to-refresh-using-On-Premise-Gateway/td-p/57857



Thanks,
Lydia Zhang