I have successfully configure D 365 FO for Power BI configuration and performed registration for Power BI
I created Power BI report using Direct Query method on AxDW of D 365 (the data was dump from one box for D 365 FO DW)
Saved the power bi file after creating a sample file with Server name as . (Period) and database name as AxDW and uploaded the file in sandbox D 365 FO LCS->Asset library and then deployed the file from D 365 FO. The file got the successfully deployed but when we are opening the report in the report catalog the report is displayed as blank and no data is displayed.
When I tried approach where I used the development environment of D365 FO wherein worked with IT admin to install the DW in SQL Azure and than created sample reports. Followed the same steps of configuration and deployment and deployed the reports in sandbox env. (ample file with Server name as . (Period) and database name as AxDW). When opening the report catalog the data is static means that data that was displayed in development env. is not getting refreshed in sandbox env.
I guess i have exhausted my option doing google search on the issue and look forward to the community to help me out.My need is simple. I need to create custome Power BI reports in sandbox and then eventually roll out in production.
Thanks
Yugank
