Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Cause of data refresh issue

Really just looking for confirmation on this. I have a a data set in Azure SQL DB with about 6 queries that in Power BI for O365 (Power BI 1.0) was refreshing all of the queries automatically except ...
Need Help
Vicky_Song's avatar
Vicky_Song
Icon for Impactful Individual rankImpactful Individual
10 years ago

Greg_Deckler, we tested on our side that it is possible to refresh a dataset with query connecting to Azure SQL database with “EXEC” statement.

 

As you have more than 1 query, how about you first refresh it in Power BI desktop? Then go Edit Queries -> Advanced Editor to find out which query cause the refresh failure? 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Thanks for following-up Vicky. The issue is that they all work from Excel. Let me back-up. The file is an Excel file built with Power Query. Had to do it this way due to customer interface constraints. Loaded Excel file on OneDrive for Business and connected it to Power BI (not import). When going to Schedule Refresh, it just says "one of your queries does not support refresh". The old O365 Power BI would refesh all of them automatically except the EXEC query. If necessary, I can probably get someone at Power BI access to the Power BI tenant, etc.

 

Perhaps I need to open up a formal support ticket for this?