Forum Discussion

julesdude7's avatar
julesdude7
Frequent Visitor
2 years ago

Error - 'Can't save dataflow. One or more tables references a dynamic data source'

Hello all, I have an issue transferring some M from desktop (where it works fine) to run in the service. let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi julesdude7 ,

If I understand correctly, the issue is that you encountered the error when trying to create the table as a dataflow. Please try the following methods and check if they can solve your problem:

1.Dataflows do not work with dynamic urls. You can view the following link to learn the issue.

Solved: Error - "One or more table references a dynamic Da... - Microsoft Fabric Community

 

2.Review any additional error messages provided in the Power BI service.

 

3.Check that the gateway is correctly configured and the credentials are up to date.

 

Best Regards,

Wisdom Wu

julesdude7's avatar
julesdude7
Frequent Visitor
2 years ago

Anonymous thank you.

You'll have to excuse me as I'm not the best at M. The link you provided suggests using relative path as an alternative. How would I implement this modifying the code above?