Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Jamey

Date Table does not work after report is published

Submitted by Helper I on ‎12-21-2021 12:32 PM

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?

Status: Investigating

Hi @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.

 

vcazhengmsft_0-1640153783000.png

 

 

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.

vcazhengmsft_1-1640153783006.png

 

 

If there is anything I misunderstand, please feel free to let me know. Thanks!

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
4 Comments (4 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎12-21-2021 10:16 PM
Status changed to: Investigating

Hi @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.

 

vcazhengmsft_0-1640153783000.png

 

 

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.

vcazhengmsft_1-1640153783006.png

 

 

If there is anything I misunderstand, please feel free to let me know. Thanks!

 

Best Regards,

Community Support Team _ Caiyun

Jamey
Helper I
Helper I
‎12-22-2021 03:58 AM

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
Helper I
Helper I
‎12-27-2021 06:19 AM

This is still an issue, can anyone help me with this or do remote session to see what's going on?

v-cazheng-msft
Community Support
Community Support
‎12-27-2021 05:08 PM

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

Idea Statuses