Forum Discussion
Web API Connection Stuck on Evaluating
eduardomaia,
What specific operations(merge/append/add custom columns) do you take in Query Editor? How many rows does your API return and how many queries in Query Editor?"If I maintain the queries only on power query and create the connection with the .xlsx file, is it possible to run and update through Power BI? Also, is it possible to load the data model to Power BI Web?"
Based on the above description, do you want to connect to the data source from Power Query of Excel and update the Excel file via Power BI? If so, it is possible.
Just make sure you select Add this data to the Data Model when loading data from Power Query to Excel. For more details, please review this article: https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive
Regards,
Lydia
eduardomaia,
What specific operations(merge/append/add custom columns) do you take in Query Editor? How many rows does your API return and how many queries in Query Editor?
"If I maintain the queries only on power query and create the connection with the .xlsx file, is it possible to run and update through Power BI? Also, is it possible to load the data model to Power BI Web?"
Based on the above description, do you want to connect to the data source from Power Query of Excel and update the Excel file via Power BI? If so, it is possible.
Just make sure you select Add this data to the Data Model when loading data from Power Query to Excel. For more details, please review this article: https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive
Regards,
Lydia