I'm using a Direct Query Report and I needed to create a Date Table to use the dates from two different tables. I first created a Power BI date table and it worked in the desktop app but when I published it, no data showed. I then created a Date Table in my Oracle Database and used the Direct Query version instead but I had the same result. When published it uses the Gateway (just updated too). Can you help?
4 Comments
v-cazheng-msftCommunity Support
Status changed:NewtoInvestigatingHi Jamey
May I know whether you can see the data from other tables except the Date table? If you couldn’t see all the data, please see the content below. Is your gateway a standard mode on-premises data gateway? Did you successfully configure data source for the report after you publishing it to Power BI service? For how to configure it, please refer Add or remove a gateway data source. If you there is nothing wrongly with configuring data source, please go to Datasets settings pane to check whether the data source used in this report has been mapped to the configured one.
Also, please check the status of your gateways in your gateway cluster and make sure they’re online by Power Platform admin center. And your database must be running as well.
If there is anything I misunderstand, please feel free to let me know. Thanks!
Best Regards,
Community Support Team _ Caiyun
JameyHelper I
Hi Caiyun,
My status in Online and my data source is present and working and it's using the correct dataset. I have one visual that does not rely on the date slicer and that works. The visuals that do rely on the date slicer that is tied to the Date Table does not work. Again, it does work in Power Bi Desktop.
- Jamey
This is still an issue, can anyone help me with this or do remote session to see what's going on?
- v-cazheng-msft
Hi Jamey
Please open a support ticket by following the steps in the blog below. And then there will be a support engineer help you troubleshoot on this issue. Thanks.
Blog: How to create a support ticket
Best Regards,
Community Support Team _ Caiyun