Forum Discussion
Import vs Direct query for reports visualized on sharepoint
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.
"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
I can't open a ticket and request support as I am only offered Q&A/fixed replies...