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
Super User
8 years ago

Hi there Anonymous

 

Are you able to run Profiler on the source database?

 

The reason that I ask is possibly your initial result is text based, and even though you are specifying the DateTime.ToText I wonder if that is actually happening.

 

What happens if you change it from the original to

 

let
    Result = "'" & Text.From(Date.From(DateTime.LocalNow(), "yyyy-MM-dd")) & "'"
in
    Result

To ensure that it is only passing a Date and not DateTime?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Really quite a good suggestion GilbertQ, although it didn't pan out.  Same result.

 

Can you give me some info on the profiler for the source database you are talking about?  Azure is still a little new to me, I haven't been given much access to know what tools are available.  I can get the Azure owner in our organisation to run it for me.

  • 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
    Super 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.

  • GilbertQ's avatar
    GilbertQ
    Super 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 "