topic Re: updating a report and the data in Developer

updating a report and the data

ntomby — Thu, 25 May 2017 12:31:11 GMT

Hi, please help. I have quries that use the sql server, I made changes on the sql server and the quries got updated. However the issue is the data (tab below report and above relationships on the left side of powerBI) and the report did not. Please help I imported the database using import data connection mode

Re: updating a report and the data

Greg_Deckler — Thu, 25 May 2017 12:32:56 GMT

On Home tab click Refresh?

Re: updating a report and the data

ntomby — Thu, 25 May 2017 12:34:18 GMT

Thank you, but i tried that several times

Re: updating a report and the data

ntomby — Thu, 25 May 2017 12:43:34 GMT

Re: updating a report and the data

ntomby — Thu, 25 May 2017 12:45:29 GMT

where there is "data" thats where the data does not change according to the query and the report too. Ofwhich i think the report does not change because the data is not updating according to the querie

Re: updating a report and the data

Eric_Zhang — Fri, 26 May 2017 06:38:43 GMT

ntomby wrote:

where there is "data" thats where the data does not change according to the query and the report too. Ofwhich i think the report does not change because the data is not updating according to the querie

ntomby

What does the query like in "Query Editor" window? Have you re-run the query and "Apply changes"?

Re: updating a report and the data

ntomby — Fri, 26 May 2017 06:41:44 GMT

Yes I have after making changes in the sql server, so the changes reflected on the quries after I refreshed but not on the data

Re: updating a report and the data

Eric_Zhang — Fri, 26 May 2017 06:45:27 GMT

ntomby wrote:

Yes I have after making changes in the sql server, so the changes reflected on the quries after I refreshed but not on the data

ntomby

What do you mean changes reflected on the queries? Do you mean that you've changed some data in SQL Server and the same quries return different result in tool like SSMS but not in Power BI? If so, what are the queries used in Power BI?