Jamey's avatar
Jamey
Icon for Helper I rankHelper I
4 years ago
Status:
Investigating

Date Table does not work after report is published

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 publi...
Gateways
Reports
v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
4 years ago
Status changed:
New
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.

 

 

 

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

Completed Ideas