Forum Discussion
Advocate IPower BI Web Refresh issue: Expression.Error
Hi andershh,
What is your data source and have you made any changes in the COUNTMARKETINGSTATUS table?
I would recommend you check that if your account that used to connect to the data source has sufficient permissions on this COUNTMARKETINGSTATUS table. If there is no issue with permission, please delete the data source under gateway and re-create the data source, then check if you can refresh the dataset successfully.
Moreover, please make sure that the connection string parameters of the data source under gateway are same as that in Power BI Desktop.
Thanks,
Lydia Zhang
Hi andershh,
What is your data source and have you made any changes in the COUNTMARKETINGSTATUS table?
I would recommend you check that if your account that used to connect to the data source has sufficient permissions on this COUNTMARKETINGSTATUS table. If there is no issue with permission, please delete the data source under gateway and re-create the data source, then check if you can refresh the dataset successfully.
Moreover, please make sure that the connection string parameters of the data source under gateway are same as that in Power BI Desktop.
Thanks,
Lydia Zhang
andershhHi Anonymous - thank you for your reply!
It turned out the issue was both due to a permission issue for the table, and that the Data Souce name didn't completely match (different cases) between the queries and the gateway (as suggested by ToddChitt in his second reply here: http://community.powerbi.com/t5/Service/How-to-remove-personal-gateway-from-app-powerbi-com/td-p/7252/page/2).
Thanks for the help!
Best,
Anders Hartzen