Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Has the ability to refresh a dataset with a dynamic SQL stored procedure been disabled?

Up until today, I had a dataset that was able to be refreshed perfectly fine through the Service.  This particular query has a single database as a source, which is an Azure Database.  The dataset us...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Microsoft have solved this on the backend and it is working again.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago

Hi Anonymous

 

Pity I was hoping that might be the work around.

 

SQL Profiler basically returns everything happening on the database. So you are able to see firstly if the query is getting to the database. As well if it is, what exactly it is sending to SQL Server.

 

If you have a DBA and explain that you want a trace from Power BI, and co-ordinate a time I am fairly certain they will be able to give you the results.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks GilbertQ.  I'll get that organised.  Any luck it will turn up some new detail.  My gut instinct is still that MS have changed something on us, but it is always prudant to get all of the data together.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Microsoft have solved this on the backend and it is working again.

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    8 years ago
    I totally agree with you that possibly something has changed.

    But also good just to double check everything is working from your side.
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Had a response from the ticket acknowledging this issue and stating:

     

    "I got information that the fix will be available on prod by 4/23/2018.
     
    Best Regards,
    Qiuyun Yu "