Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Import vs Direct query for reports visualized on sharepoint

Hello everyone,   I am making a report that will be published and shared/visualized on a sharepoint page.   The data will come from an Azure DB and I don't understand if I should use import or di...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi V-lianl-msft

 

I will be using import as suggested by @edhans.

 

Now, I have published the report and I went into the Dataset and clicked on Schedule Refresh. I have downloaded the gateway connection and entered with my credentials. I don't get why I need to have a gateway connection if the only data I need is provided only by the Azure DB. 

 

 

Also, I don't understand why I can't setup a refresh schedule yet.

 

 

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Anonymous wrote:

Hi V-lianl-msft

 

I will be using import as suggested by @edhans.

 

Now, I have published the report and I went into the Dataset and clicked on Schedule Refresh. I have downloaded the gateway connection and entered with my credentials. I don't get why I need to have a gateway connection if the only data I need is provided only by the Azure DB. 

I misunderstood your description before. As you said, using only azure SQL database as the data source does not require a gateway.

In my previous tests, when I changed the direct query mode to import mode, I also failed to set the schedule refresh. I deleted the old dataset in service and republished the changed report, and it worked.

If the problem persists,you could create a support ticket for further help.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    "In my previous tests, when I changed the direct query mode to import mode, I also failed to set the schedule refresh. I deleted the old dataset in service and republished the changed report, and it worked."

     

    I don't understand how to delete the old dataset service. When I click  on the 'Ok convert to import mode instead of direct query', I get the dataset downloaded automtically, so it doesn't seem like I need to do further actions.

     

    Anyway, after I shifted to import mode, I can see that in my Azure SQL database there are new rows and they are not retrieved by the Power BI report, so I will open a ticket as something is not working as intended.

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I can't open a ticket and request support as I am only offered Q&A/fixed replies...